The MySQL software comes with additional tools for backing up and restoring databases. As of 2011-12, the administrative tool is called "MySQL Workbench," whereas the earlier one was called "MySQL Administrator." However, "MySQL Workbench" cannot schedule backups.
Batch file, for scheduling backups
Backing Up
- Create a batch file (like this one:
mysql_batch.bat) that runs the backup-to-file command
...
C:\>"C:\Program Files\MySQL\MySQL Server 5.5\bin\mysql" --user=root --password= < C:\matlab\spm8\toolbox\CSPM\database\DBbackup_14-Feb-12.sql
MySQL Administrator
Backing up (MySQL Administrator)
...