Backup Database & Backup Projects

Previous  Index  Next  How To Use

There are two ways to create a backup of your database, right click a database in the Enterprise Manager and select Administration & Maintenance | Backup Database: this will open a backup dialog which is different for each database engine. If a backup project for the selected database exists, the dialog will show the settings from the backup project.


Below is an example:


MySQL Backup Database Dialog


Using the OK button will open the Backup Progress screen and gives you the possibility to start running the backup.


Backup Projects

The Enterprise Manager also shows "Backup Projects" for particular servers.


Backup projects are useful when you want to store your backup settings and re-use them when running regular backups from within Database Workbench. You can create, alter, delete and execute backup projects from the Backup Project Manager.


The Backup Projects for a registered MySQL server


As you can see, the Backup Project Manager displays the same functionality as the Backup Dialog. The green Execute Backup Project button starts the Backup Progress screen and allows you to create the backup.


For detailed information on database engine specific features:

Backup Database for InterBase

Backup Database for Firebird

Backup Database for MySQL

Backup Database for Sybase Anywhere