The Database Feature ensures that tables be locked and flushed before a backup operation can take place. Database feature coordinates with the point-in-time file system snapshot.
The Database feature requires you to specify a database account with administrative privileges that is used by the Backup Agent to flush tables with read lock before the file system snapshot is taken. And the lock must be held until the snapshot completes.
If you use Server Backup to backup MySQL and do not use the Database feature, then the table lock and flush operation will not take place and your MySQL backup may likely be corrupt.
Do the following to backup your database:
- Upload Java connector. See Install MySQL Connector JDBC into Server Backup.
- Create a Policy for the Server. On the "MySQL" tab, add your database instance(s) and specify other settings. See Add a MySQL instance to a policy.
- Run the created Policy.
In the Backup Manager, end-user level databases backup is not supported. Only super-users can fulfill databases backup.
See also Protect MySQL.
The following pages instruct how to restore MySQL:
- Best practices for MySQL instance restore — Best practices for restoring an entire MySQL instance on Windows and Linux.
- Browse MySQL instances — Instructions on how to browse a MySQL instance added to a policy in Server Backup Manager.
- Restore a MySQL database to the original location — Instructions on how to restore a MySQL database in Server Backup Manager.
- Restore a MySQL database to an alternate location — Instructions on how to restore a MySQL database to an alternate server with Server Backup Manager.