Choose your database:
AnySQL
MySQL
MS SQL Server
PostgreSQL
SQLite
Firebird
Oracle
SQL Anywhere
DB2
MaxDB

Subscribe to our news:
Partners
Testimonials
David Boccabella: "I am getting my manager to purchase your excellent product in a couple of day. It has really proved useful with working with the advanced features of MySQL".
Mark J Nijland: "I have used the trial versions of your software for a couple of days now. It has been one of those increasingly rare experiences. They simply work, have rich feature sets, are superbly designed, and exceed my highest expectations".

More

Add your opinion

Customers
Download Buy

SQL Maestro for MySQL online help

Prev Return to chapter overview Next

Backup Database

The Database Backup tool allows you to dump the whole database as well as selected tables. To invoke the window select the Tools | Backup Database main menu item.

 

The tool actually automates your work with the mysqldump client. The topic contains a very general overview of how SQL Maestro for MySQL doing a backup. Please refer to MySQL documentation for detailed information on mysqldump options.

 

To get the prepared command line to the mysqldump:

•select the objects to export: the whole database or selected tables;
•specify the name of the output dump file;
•select tables to be dumped (in case of tables backup);
•set additional options to create more suitable backup.

 



Prev Return to chapter overview Next