Windows Batch File: How to Backup MySQL to WinRar passworded file and upload it to SkyDrive

Following is a batch file I’ve created to backup my MySQL database. It compresses the backup to a passworded WinRar file. Which is then uploaded by the same batch file to my free 25gb Microsoft SkyDrive account (you can use any cloud storage provider which can be mapped to drive letter). Batch script then automatically names created backup using the current date and time stamp. It then deletes all WinRar files older than 30 days on SkyDrive, thus rotating backups for me automatically. Batch file can be scheduled to run as often as needed. [Read more…]