Skip navigation links
MySQL Administrator :: 17 Restore :: 17.2 The General Tab
17.3 Restore Content »
Section Navigation      [Toggle]

17.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 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 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 Auto-Detect Character Set button to have MySQL Administrator attempt to determine it automatically.