Backing up MySQL Databases

AntiThesis

Executive Member
Joined
Jul 30, 2005
Messages
5,595
Reaction score
217
Location
East London
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.
 
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/
 
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.
 
Top
Sign up to the MyBroadband newsletter
X