Backup MySQL on Windows with a Batch file

In order to back up a MySQL database server on Windows, create a batch file to call mysqldump and create a Scheduled Task in Windows to call that batch file.

I found a good solution by “Bradford Mitchell” in the comments to the mysqldump documentation.

Since I got some errors like “28 Was Unexpected At This Time“, I did some adjustments to the file (primarily, I added quotes around several paths).

Please download my version if you like

(Keywords: mysql my-sql backup back up windows microsoft batch command script file)

Leave a Reply

Your email address will not be published. Required fields are marked *

*

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>