MySQL Plug-in: Restoring

To restore a backup made with the MySQL plug-in, follow these steps:

  1. Click the New Task icon on the toolbar.
  2. Select Restore task, and then click Next.
  3. Browse for the index file (backup.hbi) located in the destination folder. Select it, and then click Next.
  4. In the Select Restore Locations dialog, verify the details of restoration.
MySQL restore locations

Selecting MySQL restoration paths

Note: The MySQL plug-in requires you to have a configuration that defines how to connect to the database. If you are restoring the backup on the same machine where it was made, then you should already have it. If you want to restore the backup with a different or fresh installation of Handy Backup, you need to create it. To do it, follow these steps:

  1. 4.1. In the Select Restore Locations dialog, select any object (database or table), and then click Change Location. The Change restore location dialog opens.
Changing MySQL restore paths

Changing restore location to create a MySQL configuration

  1. 4.2. Make sure that MySQL is selected in the left pane. In the right pane, double-click New configuration. The Settings dialog opens.
  2. 4.3. Create a MySQL configuration named identically to the original configuration. To learn how to do it, please see MySQL Plug-in: Configurations.
  3. 4.4. After creating the configuration, click Cancel to return to the Select Restore Locations dialog. You don’t need to actually change restore location, only create the configuration.

After selecting the backup to be restored, you will need to select type of restoration, enter decryption password (for an encrypted backup), etc. These steps are not specific to MySQL, and you can find the respective instructions in the Restore Task chapter.

 

Tags: restore backup

 

User Manual contents

Who uses Handy Backup?