Shulou(Shulou.com)06/01 Report--

The database of the innodb engine can be backed up with mysqldump. If the table is large, dozens of gigabytes or even hundreds of gigabytes, it will be very slow to back up with mysqldump. Then you can quickly back up the innodb database online using xtrabackup.

InnoDB has a commercial InnoDB Hotbackup that enables online hot backup of InnoDB engine tables. Xtrabackup, produced by percona, is an open source alternative to InnoDB Hotbackup, which can physically back up the tables of the InnoDB/XtraDB engine online. Innobackupex is modified with reference to InnoDB Hotbackup's innoback script, mainly to facilitate simultaneous backup of InnoDB and MyISAM engine tables, and to add some options, such as-slave-info can record backup and restore, as some information needed by slave, according to this information, you can easily use backup to redo slave.

The latest download address is as follows:

Http://www.percona.com/mysql/xtrabackup/0.7/

The installation is as follows:

Tar zxf xtrabackup-0.7.tar.gz

Cd xtrabackup-0.7

. / configure

Make

Never make install, but follow the steps below.

Cd innobase/xtrabackup/

Make

Make install

Then, two tools will be installed in your / usr/bin directory: xtrabackup,innobackupex-1.5.1

Xtrabackup can back up innodb data tables without locking, but this tool cannot manipulate myisam.

Innobackupex-1.5.1 is a script wrapper that can handle both innodb and myisam, but requires a read lock when dealing with myisam.

/ usr/bin/xtrabackup-- backup-- target-dir=/backup/mysqlbackup the target-dir here is the directory to which you want to back up. This tool does not need to specify a database name. By default, all databases of the innodb engine will be backed up.

When the backup is finished, you will see that there will be all the innodb engine libraries under target-dir, but oddly enough, there is no backup .frm file, this does not matter, you need to manually copy a copy.

As for recovery, copy it back and ok it.

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.