Black Friday is here! Get up to 30% off on Devart products!
ends in   {{days}}
Days
{{timeFormat.hours}}
:
{{timeFormat.minutes}}
:
{{timeFormat.seconds}}

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 or MariaDB 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 recovery
  • Schedule database backup and recovery
  • Backup and restore MySQL databases from the command line
  • Backup database structures, data, or both
  • Make selective backups
  • Get support for MySQL 5.7/8 and MariaDB 10/11

How to Backup MySQL Database through GUI


Step 1. Launch Database Backup Wizard

To launch Database Backup Wizard from dbForge Studio for MySQL:

1. On the ribbon, select Database > Tasks > Backup Database. The Database Backup Wizard opens.

2. On the General tab of the Wizard, specify a connection, a database to back up, and a name for the output file. To proceed, select Next.

MySQL Dump Tool - Launch Database Backup Wizard

Step 2. Select the backup content

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

Then, select the checkboxes next to the database objects to be included in the backup.

Select Next to proceed.

MySQL db backup - Select the backup content

Step 3. Configure the backup settings

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

The options are grouped. Use a search box, if 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, specify the behavior of the tool in case it encounters an error while performing a database 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, select Backup to start the backup process.

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

More on MySQL backup and restore command

Backup MySQL database - Complete

How to Schedule a MySQL or MariaDB Backup


Step 1. Create a backup file

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

First, you must 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, select Save > 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.
2. On the top menu, select ActionCreate Basic Task.
3. Provide a name for the new task. To proceed, select Next.
4. Select when you want the MySQL backup task to be started. Select Next.
5. Select the time and frequency for running the task. Select Next.
6. Select Start a Program and then select Next.
7. 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, 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"
8. Check all specified settings again and select Finish if no changes are required. Otherwise, select 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 and backup script generation, and manage the generation of DML statements. Unlike the binary MySQL backup process, databases are dumped in SQL format.
Whether you're working with MySQL or MariaDB, the dbForge MySQL backup tool is a reliable and efficient replacement for 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

Backup and Restore MySQL Database

dbForge for MySQL is a handy and easy-to-use GUI tool for efficient database management. MySQL's beginners will find an intuitive interface and detailed tutorials. In turn, experienced users will fully automate their daily management routine.