This solution will work for everything from Windows 10, down to XP, and Server 2003. For additional recovery, use MySQL’s Binary Log files to record transactions between backup jobs (to rebuild the database to the last transaction recorded). Have the task run a BATCH file containing the “mysqldump” and “makecab” commands to export and compress the databases. Use the Windows Task Scheduler to automatically run a backup task every day or week. The best way to create and automate backups of MySQL databases is to: 1. The alternative is to call the mysql and mysqldump executables using the full path to them (e.g F: wamp bin mysql mysql5.1.36 bin mysql and F: wamp bin mysql mysql5.1.36 bin mysqldump). You can place your file anywhere as long as you have your mysql bin folder in your PATH. Once the password is entered your dump file will be available in the root directory for your Windows user – ie. After entering that command you will be prompted for your password. To dump/export a MySQL database, execute the following command in the Windows command prompt: mysqldump -u username -p dbname >filename.sql.
