{page-title}{excerpt}Bakbone MySQL APM adds a Win32 GUI to mysqldump{excerpt}
[Bakbone|http://www.bakbone.com/] sells the [MySQL Application Plugin Module|http://www.bakbone.com/docs/NVB_APM_MySQL_Datasheet.pdf] for their Bakbone backup software for Linux. The Bakbone MySQL APM is capable of doing backup and restore using the [TP:SQL Database Dump]. Backups schedules are automated using a Windows 32-bit graphical user interface.
\\
h3. How Does Bakbone APM for MySQL Work?
\\
Bakbone simply uses runs the [mysqldump|mysqldump]utility included with MySQL to take backups.
This is taken from the BakBone MySQL APM User's Guide:
_"_{*}{_}mysqldump{_}* _\- This component allows you to perform backups/restores of multiple types of MySQL storage engines"_
[http://www.bakbone.com/docs/NetVault_Backup_APM_for_MySQL_Users_Guide.pdf]
\\ *Bakbone Point-In-Time MySQL Restore*
\\
Bakbone does advertise support for point-in-time recovery using [MySQL binary logs|TP:Binary Log Backups]. The feature is more form than function as the Bakbone restore functionality consists of copying the binary log to the MySQL server. From there the administrator must manually use the [mysqlbinlog|http://dev.mysql.com/doc/refman/5.0/en/mysqlbinlog.html] utility to actually perform the restore.
\\
\\
| {color:#cc0000}Category{color}\\ | [Legacy|TP:Categories of MySQL Backup Software]\\ |
| Archive Type | Tape or Virtual Tape Library \\ |
| MySQL Storage Engines Supported | All \\ |
| Supported O/S | All \\ |
| Binlog Backup & Restore | {color:#00cc00}Yes{color} \\ |
| {color:#cc0000}Zero Business Interruption (Online Backups){color} | {color:#cc0000}No{color}\\ |
| Granular (Table Level) Restore \\ | {color:#00cc00}Yes{color} \\ |
| Easy to Use Graphical User Interface \\ | {color:#00cc00}Yes{color} \\ |
| Complete Server Protection (Backup All Data or just MySQL?) \\ | {color:#00cc00}Yes {color} \\ |
| Backup Type \\ | [Full (Incremental with Binary Logs)|TP:Backup Method - Full Backup] \\ |
| {color:#cc3300}Backup Window Length{color} \\ | {color:#cc3300}Long{color} \\ |
| {color:#cc3300}Server Disk I/O and Load Impact{color} \\ | {color:#cc3300}Heavy{color} \\ |
\\
[Bakbone|http://www.bakbone.com/] sells the [MySQL Application Plugin Module|http://www.bakbone.com/docs/NVB_APM_MySQL_Datasheet.pdf] for their Bakbone backup software for Linux. The Bakbone MySQL APM is capable of doing backup and restore using the [TP:SQL Database Dump]. Backups schedules are automated using a Windows 32-bit graphical user interface.
\\
h3. How Does Bakbone APM for MySQL Work?
\\
Bakbone simply uses runs the [mysqldump|mysqldump]utility included with MySQL to take backups.
This is taken from the BakBone MySQL APM User's Guide:
_"_{*}{_}mysqldump{_}* _\- This component allows you to perform backups/restores of multiple types of MySQL storage engines"_
[http://www.bakbone.com/docs/NetVault_Backup_APM_for_MySQL_Users_Guide.pdf]
\\ *Bakbone Point-In-Time MySQL Restore*
\\
Bakbone does advertise support for point-in-time recovery using [MySQL binary logs|TP:Binary Log Backups]. The feature is more form than function as the Bakbone restore functionality consists of copying the binary log to the MySQL server. From there the administrator must manually use the [mysqlbinlog|http://dev.mysql.com/doc/refman/5.0/en/mysqlbinlog.html] utility to actually perform the restore.
\\
\\
| {color:#cc0000}Category{color}\\ | [Legacy|TP:Categories of MySQL Backup Software]\\ |
| Archive Type | Tape or Virtual Tape Library \\ |
| MySQL Storage Engines Supported | All \\ |
| Supported O/S | All \\ |
| Binlog Backup & Restore | {color:#00cc00}Yes{color} \\ |
| {color:#cc0000}Zero Business Interruption (Online Backups){color} | {color:#cc0000}No{color}\\ |
| Granular (Table Level) Restore \\ | {color:#00cc00}Yes{color} \\ |
| Easy to Use Graphical User Interface \\ | {color:#00cc00}Yes{color} \\ |
| Complete Server Protection (Backup All Data or just MySQL?) \\ | {color:#00cc00}Yes {color} \\ |
| Backup Type \\ | [Full (Incremental with Binary Logs)|TP:Backup Method - Full Backup] \\ |
| {color:#cc3300}Backup Window Length{color} \\ | {color:#cc3300}Long{color} \\ |
| {color:#cc3300}Server Disk I/O and Load Impact{color} \\ | {color:#cc3300}Heavy{color} \\ |
\\