using cron to backup mysql

[Anon]

Heres what the cronjobs file has in it;

0,15,30,45 /usr/home/foo/cronscripts/logfiles/sql.sh

Contents of sql.sh;

#!/bin/sh

this script will backup the mysql database

and create a file to be downloaded

via FTP scheduler

mysqldump -h hostname -u username -pmypass links > /usr/local/www/foo/sql/links.sql
mysqldump -h hostname -u username -pmypass mysql > /usr/local/www/foo/sql/mysql.sql

Question is, will this work correctly?

oli

[[deleted]]

uhm... why don't you try it and see?

[essexboyracer]

I have tested it and nothing happened, is there a problem with the sql.sh file, in particular running two mysqldump commands successivly?

oli

[[deleted]]

is mysqldump in the PATH of the cron's user profile?

or, add the full path to mysqldump to the crontab entries.

[essexboyracer]

u got me there vincent, woosh, straight over my head!

Does that mean i have to supply the path to mysqldump within the sql.sh file?

oli

[[deleted]]

lol I did a flyby.. ok..

No, not in the sql.sh, in the crontab entry.
change this:
mysqldump -h hostname -u username -pmypass links > /usr/local/www/foo/sql/links.sql

to this:
/path/to/mysqldump -h hostname -u username -pmypass links > /usr/local/www/foo/sql/links.sql

[essexboyracer]

with you vincent, i guess you know what question is coming next, but i will have a tinker first!

regards
oli

[essexboyracer]

had a read on various resources. I have an idea it changes on every machine, but is there a general thing i can do to find the location mysqldump? such as mysqldump -help?

oli

[[deleted]]

try

find / -name mysqldump