MySQL backup script automation on Windows server
Posted on 2013-02-03
I've done a lot of looking, but can't find something that covers all bases of what I want.
I'd like a backup script that I can schedule to run nightly to backup my server's MySQL databases.
It's Windows Server 2008 R2, IIS7.5, MySQL v5.1, PHP v5.4.
There is about 8 databases, but I'd like them backed up to individual files with the date in the file name. eg. database1-20130204.sql
I've read a little about mysqldump but have no idea how to make it dump the databases to individual files at the same time (i.e one script rather than a different one for each database for each day of the week).
I'd also like the dump to be on a different HDD... eg. D:\MySQL-Backups\dumps.
New databases are added or some deleted somewhat frequently, so I'd prefer not to have to adjust the backup script each time I make a change...
Can the script create a logfile about what databases were dumped that can be emailed to me using blat.exe or something?