How to Backup and Restore MySQL Database in Windows

How to Backup and Restore MySQL Database in Windows


Welcome to dbForge Studio for MySQL
Tutorials. Learn how to backup a database without
managing code with the help of dbForge
Studio for MySQL. On the Start Page click Data Pump,
and then click Backup Database. The Databse Backup Wizard opens. As you can see, the server connection and the
database are already selected. To save the disk space, you can autodelete old
backup files. Select to store only two most recent copies of
backup files, and autodelete the rest in the specified folder. To compress a backup file, let’s use a default
compression level. You can also add a comment to the backup file. Move to the Backup content wizard page to
select what you want to backup: only a structure, data or both. Now move to the Options wizard page to select
the required options. Let’s select the “Lock all tables for read”
option to prevent database changes during the
backup. To include grants for users, type the first letters
of the option’s name in the “Find” box. Click Next to setup errors handling. Select to get prompts in case of any errors, and the “Write a backup report to a log file”
option. To save time and effort next time, you can click
the “Save Project” button to save all settings
as a project. Now you can start a backup. After the backup completion you can:
– open the log file, – open the folder containing the output file,
– and save the backup project if, you haven’t
done it yet. Besides, you can backup a database with the
command line, instead of doing it manually. You can also schedule backups to automate the
bacup procedure. Here is our result. Download your free thirty-day trial of dbForge
Studio for MySQL and try it yourself.

Danny Hutson

Leave a Reply

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