MySQL Administrator :: 13.2 General

File to restore: Specify 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 we get an sql error: This will cause a restore operation to continue executing even if errors are encountered during the restore operation.

Create database(s) if they don't exist: If a database is referenced in the backup file that does not exist, the database 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.