Setting up a cronjob to back up a mySQL DB

[Justin Sampson]

Hey,
I was wondering if someone knew of a tutorial on setting up a cronjob to back up your mySQL database? Also when I do a normal mysql dump where is that file located?

Is it excsible from the web or just ftp?
I was wondering because I was going to set up a script on a free host to get the contents of the sql file regularly too and make another copy (can never be too safe).

Thanks,
Justin Sampson

[Kevin Yank]

This, in combination with the man page for 'crontab' should give you all the information you need.

http://www.webmasterbase.com/article.php/228/883

Basically, mysqldump puts the file in whatever directory you were located when you ran the program, or where you specify (if you specify a path with the output filename).