View Source

\\
{page-title}{excerpt}What Does It Really Do{excerpt}
  
\\
\\
The [MySQL Hot Backup API|http://forge.mysql.com/wiki/OnlineBackup] is MySQL's answer to the commercial backup software vendors. It's goal is to make an API for doing [Online type MySQL backups|TP:Categories of MySQL Backup Software].  It is a big goal and will represent a significant improvement over mysqlhotcopy for MyISAM backups.

For years the commercial backup software vendors have been telling MySQL AB: "build as an API and we'll build hot backup apps\!"
\\

h3. Implemented and Not Yet Released (MySQL 6.0.5 )

* Online Backup without Interruptions for InnoDB and Falcon storage engines.
* SQL Interface for Initiating Backups
* BACKUP DATABASE databasename1, databasename2 TO "filename.backup";
* RESTORE FROM "filename.backup";

h3. Limitations Still Being Worked Out

* Can't backup replicated Databases
* No backup of database privileges
* {color:#cc0000}{*}No selective (table level) backup and restore{*}{color}
* No Compression
* {color:#cc0000}{*}No MyISAM support{*}{color}
\\
\\
| {color:#cc0000}Category{color}|[Online|TP:Categories of MySQL Backup Software]
|Archive Type | Disk \\ |
| {color:#cc0000}MySQL Storage Engines Supported{color} | {color:#cc3300}InnoDB & Falcon{color} {color:#cc3300}Only{color}\\ |
| Supported O/S | All \\ |
| Binlog Backup & Restore | {color:#cc0000}No{color} |
| {color:#00cc00}Zero Business Interruption (Online Backups){color} | {color:#00cc00}Yes{color} |
| {color:#00cc00}Granular (Table Level) Restore{color} \\ | {color:#00cc00}Yes{color} \\ |
| Easy to Use Graphical User Interface \\ | {color:#cc0000}No{color} |
| Complete Server Protection (Backup All Data or just MySQL?) \\ | {color:#cc0000}No{color} |
| Backup Type \\ | [Full|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} \\ |
\\