Focus on Code

net stop mysql
rar a -ag+YYYYMMDDHHMMSS- -rr -r -k -s -m0
      C:\\BACKUPS\\MYSQL-BACKUP.RAR C:\\MYSQL\\data
net start mysql

Save three lines as something.bat or autoexec.bat and then use it by Cron Jobs. Output file names like this :


20060808120000-MYSQL-BACKUP.RAR
20060808120001-MYSQL-BACKUP.RAR
20060808120002-MYSQL-BACKUP.RAR


( Before this you can update you path configuration. You can add a line at the end of PATH variable like this : C:\Program Files\WinRAR\ etc.)

This entry was posted on Friday, October 5th, 2007 at 12:36 pm and is filed under mysql, software.You can follow any responses to this entry through the RSS 2.0 feed. You can leave a response, or trackback from your own site.