Table of Contents
The Restore section helps with disaster recover by helping you restore backup files created using MySQL Administrator. See Chapter 16, 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.
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
button at the bottom of the window. When all options are set, you can click the button to begin the restore process.The following options are available:
File to restore: Specify the path and file name of the backup file. You can browse for that file by clicking the button.
Target Schema: You can choose the option to have all tables restored into their original databases. You can also choose the 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 . Those are
backup files containing SQL statements such as those produced
by mysqldump
.
Ignore Errors: Selecting this option allows a user to continue with the restore operation even if errors are encountered. However, results are not likely to be 100% correct.
Create database(s) if they don't exist: If a nonexistent 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
button to have MySQL Administrator attempt to determine it automatically.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
button, a list of all databases and tables contained within the backup file will be displayed.To prevent a database or table from being restored, uncheck the box next to the object's name.