SQL Backup
These bat scripts dumps SQL Databases into an .sql file, then uses 7zip to compress them
Authors
- @duckerr
- Random snippets referenced from StackOverflow
Requirements
7zip
MySQL 8.0 or XAMPP
Installation
Edit either script, depending on if you are using MySQL or XAMPP, enter the correct DB credentials, and correct PATHS to files and folders needed.
For the XAMPP script, enter the name of the Database you want to backup at line 43.
For this to be automated, we will use the Task Scheduler within Windows.
Open Task Scheduler, and create a task.
Choose a name, select the options “Run whether user is logged on or not”, and the “Hidden” checkbox.
Next, go to the Actions tab and make a new one. Select the path to the script, and click OK.
Next, to to Triggers and click New. Choose One time, then check the box that says “Repeat task every:” and choose a time. Make sure the “for a duration of:” is set to Indefinitely, and the “Enabled” box at the bottom is checked.
Finally, start the task.
