Glossary Item Box

DBACentral for MySQL Submit feedback on this topic   

Backup Database Wizard

The Backup Database Wizard allows you to create a backup copy of your database in the backup directory (*.frm and *.myd files) or in SQL script. To run the wizard select the Tools | Administration Tools | Backup Database main menu item.


The first step of the wizard allows you to select the backup type and destination.

Select FRM/MYD Files to create a backup as a number of table files at the server side. Select SQL Script to generate the SQL script, which represents your database as a consecution of SQL statements (like the mysqldump utility does). 


It is highly recommended to execute "native" backup only on local server. Otherwise you have to specify the relative path and ensure that the path exists on the server machine.


The backup destination should be either a directory at the server side for storing database files or a file name for storing the generating SQL script.


The next step of the wizard is available only if you backup your database into SQL script.

The following options are available for customizing the backup script:

  • Backup Table Structure - check this option to include the CREATE TABLE statements into the dump.
  • Backup Table Data - check this option to include the INSERT statements into the dump.
  • Lock Tables - check this option to add the LOCK TABLES statements into the dump.
  • Disable Key Checks - check this option to add the DISABLE FOREIGN CHECKS statements into the dump.
  • Add DROP Statements - check this option to include a DROP TABLE IF EXISTS statement before each CREATE TABLE statement.
  • Use Extended Inserts - this open enables using a new type of the INSERT statement, containing several sets of values for each statement. 
  • Include Header - this option adds descriptive comments before each new table definition.
  • Add Create Database Statement - check this option to include a statement for database creation into the dump.


The following step is intended for selecting the backup tables.

The Available Tables contains all tables from the current database. Move the tables to the Selected Tables list to include them into the result backup.


The final step of the wizard allows you to select the action to perform after the backup and displays information about the process errors, if such occur.

The after-backup actions are available only for SQL backup. Select Load script to SQL Executor to open the result script within the SQL Executor. To open the result script in the external program, associated with SQL files, select Open the result file in the associated program. To close the wizard without any action after performing backup, select the Take no action.

To start executing backup with all the parameters you have set, click the Finish button.




©2004 MicroOLAP Technologies LTD. All Rights Reserved. All trademarks are the sole property of their respective owners.