Have you ever attempted to set up an automated backup of your MySQL database? The process of creating a scheduled backup is not as easy as SQL Server. In MySQL, we must use the command line to make this process automatically. The method uses a batch file to automatically backup and zip files each night at midnight. This happens using
mysqldump command-line tool using Windows Task Scheduler:
Here’s the command which is being called behind the scene:
This command, first backups the database then uses
7zip to zip the backup. Then the
sql is deleted as we don’t need it anymore.