InnoDB Hot Backup Manual - the Online MySQL Backup Tool

Short Description
InnoDB Hot Backup, or ibbackup, is a tool which allows you to backup a running InnoDB database under MySQL without setting any locks or disturbing normal database processing. You get a consistent copy of your database, as if the copy were taken at a precise point in time. InnoDB Hot Backup is also the ideal method of setting up new slaves if you use the MySQL replication on InnoDB tables.

Website: ssl.neutech.fi | Filesize: 493kb
No of Page(s): 37

Content
…
When the multiple tablespaces feature is enabled, it is possible to make a partial backup of the InnoDB tables. The multiple tablespaces feature allows storing each InnoDB table in a separate tablespace holding the data and indexes of one table only. A single-table tablespace consists of one autoextending datafile named table_name.ibd in the database directory of the table. Those InnoDB tables for which the multiple tablespaces feature is not enabled, are stored as usual in the system tablespace defined by the innodb_data_file_path and innodb_data_home_dir parameters in the my.cnf file.
With its –include option, ibbackup (v2.0 or higher) can be instructed to make a partial backup excluding some of the per-table datafiles. A partial backup contains the system tablespace and per-table datafiles of those tables which match the include pattern. For each table with a per-table data file a string of the form db_name.table_name is checked against the regular expression specified with the –include option. If the regular expression matches the complete string db_name.table_name, the table is included in the backup. The regular expression should be of the POSIX extended form. Note that on Unix-like systems, the regular expression should be quoted appropriately in order to prevent interpretation of shell meta-characters. This feature has been implemented with Henry Spencer’s regular expression library.
…

Get the file Download here