Database Backup and Restore

There are many reasons that can cause data loss. These are, for example, an operating system crash, power failure, hardware problem and many others. So it is necessary to back up databases periodically. With dbForge Fusion for MySQL you can perform database backup easily using the Database Backup Wizard. Fusion for MySQL backs a database up into a simple SQL script. You can read and correct this script.

With Fusion for MySQL you can perform full database backup or restoring only selected database objects.

To call the Database Backup Wizard, on the Fusion menu, select MySQL, and then click Backup Database. Or use the shortcut menu of the database node in the Database Explorer window.

Backing Up an Entire Database

  1. Select a database to back up, backup script file name and location, click the Next button.
  2. Select Structure and Data, check Include all objects, click the Next button.
  3. Set the backup options, click the Backup button.
  4. Choose whether to open the backup script file in SQL Editor and wether to save the backup project for future use, and click the Finish button.

Backing Up Certain Database Objects

  1. Choose a database to back up, script file name and location, click the Next button.
  2. Select required information to backup.
  3. Select database objects to back up their structure if you have chosen Structure or Data to back up on the Backup Content page, click the Next button.
  4. Select tables to back up their data if you have chosen Data or Structure to back up on the Backup Content page, click the Next button.
  5. Set backup options, click the Backup button.
  6. Choose whether to open the backup script file in SQL Editor and whether to save the backup project for future use, and click the Finish button.

Restoring Database from Backup Script

To call the Database Restore Wizard and restore the database from the backup script:

  1. On the Fusion menu, select MySQL, and click Restore Database on the Database menu or on the shortcut menu of a database node in the Database Explorer window.
  2. Select backup script file to restore and target database. If backup script file contains the CREATE DATABASE statement, backup data will be restored to the created database instead of the selected database.
  3. Check that the encoding for the restored file is selected correctly. The program automatically selects it basing on the restored file, if it fails, the default encoding (the current Windows encoding on the machine where Fusion for MySQL is running) is selected. You can always select a required encoding from the drop-down list.
  4. Click the Restore button.

Note

If you back up and restore database on different MySQL versions, you may encounter errors.