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.
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