Backing up MySQL Databases

[AntiThesis]

Does anyone know of any (preferably free) solutions to backup a series of MySQL databases every day? Unfortunately they're running on a windows 2000 server so no cron jobs.

 

[wizzard]

I use the mysql Administrator tool that you can get for free from mysql. It lets you select which databases or even tables to backup, what days/times to back them up, and puts it all in a nice sql file for you.

It also is setup so that you dont have to have anyone logged on, it can use a user/pass to log on and do the process itself.

More info here:
http://www.mysql.com/products/tools/administrator/

 

[Nod]

W2k server still have scheduled tasks if I remember correctly, so writing a bat-file with a mysqldump command might also do the trick. The Administrator tool is the easiest to use though.

 

[AntiThesis]

Thanks wizzard That will work just fine. Dunno how I missed that actually

 

[Moederloos]

get cron for windows.
I use that with no problems