Does anyone know of a good, free and reliable tool that does automatic schedules backups of MySQL databases? I found MySQL Watch, but it's a paid program and i have no will to pay any money for anything at the moment.... :S

are there any opensource tools out there? or maybe some other solution?

thanks!

------------------------
Julio

PHP | MySQL | DWMX

ICQ: 19735247
MSN: rantbox@hotmail.com

two options that come with mysql:

1. use the mysqldump program to dump your database to a SQL script, or better,
2. use the mysqlhotcopy script to backup the database. it's a perl script, so you'll have to have perl and the DBI package installed

you can use cron to call the script periodically.

allan

<img src=../images/dmxzone/forum/icon_smile_cool.gif border=0 align=middle><img src=../images/dmxzone/forum/icon_smile_cool.gif border=0 align=middle><img src=../images/dmxzone/forum/icon_smile_tongue.gif border=0 align=middle>