MySQL Dump Tool for Database Administrators

The MySQL backup tool that comes with dbForge Studio for MySQL is designed to help database administrators and developers back up and restore MySQL databases with the maximum quality and speed.

dbForge Studio for MySQL is an industry-standard solution allowing you to efficiently perform database backup and restore tasks in a convenient and well-designed GUI:

  • Automate database backup and restore
  • Schedule database backup and restore
  • Backup and restore MySQL databases using the Command Line
  • Backup database structure, data, or both
  • Selective backup capability

How to Backup MySQL Database through GUI


Step 1. Launch Database Backup Wizard

To launch Database Backup Wizard from dbForge Studio for MySQL:

1. Right-click the required database in the Database Explorer window, point to Backup and Restore, and select the Backup Database option. The Database Backup Wizard opens.

2. On the General tab of the Wizard, specify a connection, a database to backup, and a name for the output file. Click Next.

MySQL Dump Tool - Launch Database Backup Wizard

Step 2. Select the backup content

On the Backup content tab of the Wizard, select to backup database structure, data, or both.

Then tick the necessary check boxes to select database objects to be included in the backup.

Click Next to proceed.

MySQL db backup - Select the backup content

Step 3. Configure the backup settings

On the Options tab of the Database Backup Wizard, configure the backup script generation options.

For convenience, options are grouped. Use a search box, in case you're experiencing difficulties finding the required option.

MySQL dump tool - Configure options

Step 4. Specify Errors handling and Log settings options

On the Errors handling tab, you need to specify the behavior of the tool in case it encounters an error while performing a db backup. You can select from the following options:

  • Prompt a user for an action
  • Ignore all errors
  • Abort at the first error

On the tab, you can also select to write a report to a log file and specify a path to it.

MySQL backup utility - Configure errors handling

Step 5. Complete the backup

After you've configured all the necessary options on the tabs of the Database Backup Wizard, click the Backup button to start the backup process.

When the backup is complete, you can view the log file and view the backup file in the folder specified. Click Finish to exit Database Backup Wizard.

More on MySQL backup and restore command

Backup MySQL database - Complete

How to Schedule a MySQL Backup


Step 1. Create a backup file

Backup tasks automation and scheduling eliminate a need for running manual backups and saves much time and effort.

First, you will need to create a project file, containing the required backup settings.

To create a backup project file, complete the steps 1-5 above. On the final tab of the Database Backup Wizard, click Save Project and specify a path to a folder on your computer where you want this file to be stored.

Once all the needed options for the backup are selected and the project file is created and saved, you'll need to schedule the task with the help of Task Scheduler for Windows.

More on MySQL db dump command

MySQL backup utility - Save backup file

Step 2. Schedule the task using Task Scheduler

1. Start Task Scheduler for Windows.
3. Select ActionCreate Basic Task in the top menu.
4. Provide a name for the new task. Click Next.
5. Select when you want the MySQL backup task to be started. Click Next.
6. Select time and frequency for running the task. Click Next.
7. Select Start a Program and click Next.
8. Enter a path to the dbforgemysql.com file in Program/script field. (The default path is "C:\Program Files\Devart\dbForge Studio for MySQL\dbforgemysql.com")
On the Start a Program tab, also make sure to specify arguments in the Add arguments field. For example:
/backup /connection:"User Id=root;Host=db;Port=3309;Database=sakila;Character Set=utf8;" /projectfile:"C:\Users\Documents\dbForge Studio for MySQL\Export\sakila.backup"
9. Check all specified settings once again and, if no changes are required, click Finish . Otherwise click Back and make the needed changes.

Backup MySQL database - Complete

Conclusion

MySQL Dump Tool allows you to significantly save your time and effort when developing and administering databases. It allows you to select a level to compress your files, auto delete old MySQL backup files, and set extended options to control your backup structure, backup script generation as well as manage the generation of DML statements. Unlike binary MySQL backup process, databases are dumped in SQL format.
dbForge MySQL backup tool can be used as a full replacement of the MySQL Dump command line tool.

dbForge Studio for MySQL

The most intelligent tool for MySQL development and management

Availability in the editions of dbForge Studio for MySQL

Feature

Enterprise
Professional
Standard
Express
Database backup and restore wizards
Yes
Yes
Yes
Command-line interface for database backup and restore
Yes
Yes
None
None