Table of Contents
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.
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
filename of the backup file. You can browse for that file by
clicking the 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
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.