Backing up several databases

I'd like to know what is the best way to periodically backup several MySQL databases (some over 500Mb).

Is there any script available that can be run on cron? Any other ideas?

Thanks for any help.

 

hello use mysqldump by shell or shell script or use exec by php and add in cron

example
mysqldump -u username -p --all-databases

 

Hi amarques,

I use Amanda open source backup (http://amanda.zmanda.com/) to take daily remote backups. The setup isn't too hard and you can just add it to cron and forget it.

Petey

 

Thanks guys,

I'll give it a try.

Thanks again for your help.

 

There's also a nice script called AutoMySQLBackup (I think) on the GNU

 

I consider MySQL's command line syntax reliable.