Choosing Between Binary and Dump Modes
The following table article aims at helping you choose between backup techniques supported by the Bacula Enterprise MySQL Plugin. Major functionalities such as being able to restore your database at any point in time, or being able to filter objects during backup or restore should guide you. It is also possible to combine Dump and Binary techniques for the same server.
Functionality |
Dump |
Binary |
|---|---|---|
Can restore directly a single object (table, schema…) |
Yes |
No |
Backup speed |
Slow |
Fast |
Restore speed |
Very Slow |
Fast |
Backup size |
Small |
Big |
Can restore at any point in time |
Yes |
Yes |
Incremental/Differential support |
Yes |
Yes |
Online backup |
Yes |
Yes |
Consistent |
Yes |
Yes |
Can restore to previous major version of MySQL |
Yes |
No |
Can restore to newer major version of MySQL |
Yes |
No |
1 To restore a single object, the dump file must be edited.
2 To restore an SQL dump to a previous version of MySQL, you might have to
edit the SQL file if you use features that are not available in the previous
version. Generally, restoring to a previous version of MySQL is neither
supported nor guaranteed.
Go back to the main Backup Strategies page.
Go back to the main MySQL Plugin page.
Go back to the Dedicated Backup Solutions page.