Backup and Restore

Both backup and restore works only with MySQL. MySQL Backups use the mysqldump program. Restore uses the MySQL program. The correct version of these programs must be on the PATH so that the server can execute them. The MySQL backup files are automatically compressed with gzip and will have a .gz extension. The restore procedure can operate on both compressed (.gz) and uncompressed (.cbk) files. Uncompressed encrypted backup files have an extension of (.cbe).

Instructions to restore a backup

To backup the database:

1 Log in to the Management System and click "Manage Databases."
2 Click the database and choose "Backup."
3 Note the backup location and click the "Backup" button.
If encrypted backups are enabled, a warning will appear

Restoring a Database Backup

1 Log in to the Management System and click "Manage Databases".
2 Click the database and open "Properties".
3 Check the box marked "Suspend this account temporarily" and click the "Save" button.
4 Click the database again and choose "Restore backup."
5 The backup files are stored in /var/caw-backups. Click the backup to restore and choose "Restore backup." If encrypted backups are enabled, it will prompt to enter the private key.
6 Open the "Properties" page again and uncheck "Suspend this account temporarily." Log out of the "Management System" and log in to the database.