Chapter 15. Restore

Table of Contents

15.1. Introduction
15.2. The General Tab
15.3. Restore Content

15.1. Introduction

The Restore section helps with disaster recover by helping you restore backup files created using MySQL Administrator. See Chapter 14, Backup for more information on creating backups with MySQL Administrator.

The backup files created by MySQL Administrator are similar but not identical to those created by mysqldump. A consequence of the differences is that MySQL Administrator cannot read dump files created by mysqldump.

15.2. The General Tab

In this tab, you specify which backup file should be restored, the character set and format, and the target location for restored tables.

To set any options on this tab, you must first open a backup file by clicking the Open Backup File button at the bottom of the window. When all options are set, you can click the Start Restore button to begin the restore process.

The following options are available:

  • File to restore: Specify the path and filename of the backup file. You can browse for that file by clicking the Open Backup File button.

  • Target Schema: You can choose the Original Schema option to have all tables restored into their original databases. You can also choose the New Schema … option to restore all tables into a new database. Finally you can choose from one of the existing databases in the drop-down list to force all tables to be restored to that database.

  • Backup Type: At the moment, the only available option is SQL Files. Those are backup files containing SQL statements such as those produced by mysqldump.

  • Force – Continue even if there is an sql error: This will allow a restore operation to proceed even if errors are encountered.

  • Create database(s) if they don't exist: If a non-existent database is referenced it will automatically be created if this option is checked.

  • File Charset: Backup files created with MySQL Administrator are encoded in the utf8 character set. Backup files created with other tools such as winmysqladmin may be encoded with other character sets. Before a backup file can be successfully imported you will need to specify its character set.

    If you do not know the character set of your backup file, click the Auto-Detect Character Set button to have MySQL Administrator attempt to determine it automatically.

15.3. Restore Content

If you do not wish to restore all the databases or tables listed within your backup file, you can use the Restore Content tab to limit which databases and tables are restored.

After clicking the Analyze Backup File Content button, a list of all databases and tables contained within the backup file will be displayed.

Figure 15.1. The Restore Content tab

The Restore Content tab

To prevent a database or table from being restored, uncheck the box next to the object's name.