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

Subscribe to our news:
Partners
Testimonials
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".
David Boccabella: "I have really!!!! enjoyed using SQL Maestro for MySQL over the past few months. It has become one of our major development tools for implementing intelligent into MySQL databases".

More

Add your opinion

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