Auto Backup and Restore of MYSQL Database using Command Prompt.
How to auto backup MySQL database using batch script.
You can create your own schedule database backup like- after every 1 hour a new backup will be generated. Backup filename will be present date & time. So no need to worry about data loss.
Create your own restore batch file that once clicked will restore the database.
I will add the code on comment box as description is not accepting it.
Back Up and Restore MySQL Databases Using MySQL Workbench
[ Ссылка ]
Basic SQL Tutorial For Beginners In 10 minutes | Creating and Manipulating Databases
[ Ссылка ]
Ещё видео!