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 file name 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
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
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.