MySQLXtrabackup backup and recovery _ MySQL

MySQLXtrabackup backup and recovery bitsCN.com Xtrabackup is a data backup tool for InnoDB. it supports online hot backup (which does not affect data reading and writing during backup) and is a good alternative to InnoDB Hotbackup. Xtrabackup has two main tools: xtrabackup and innobackupex. xtrabackup can only back up InnoDB and XtraDB data tables. innobackupex encapsulates xtrabackup and can back up MyISAM data tables. 1. install mysql 2. install Xtrabackup and download the Xtrabackup configuration source # vi/etc/yum. repos. d/percona. repo Java code [percona] name = CentOS $ releasever-Percona baseurl = http://repo.percona.com/centos/ $ Releasever/OS/$ basearch/enabled = 1 gpgkey = file:///etc/pki/rpm-gpg/RPM-GPG-KEY-percona Gpgcheck = 1 add key # cd/etc/pki/rpm-gpg # wget http://www.percona.com/downloads/RPM-GPG-KEY-percona Install Xtrabackup yum install xtrabackup 3 backup # xtrabackup -- backup -- datadir =/var/lib/mysql/-- target-dir =/data/backups/mysql/4 recover backup data. stop MySQL service: $/etc/init. d/mysqld stop or service mysql stop B. modify my. cnf datadir to the backup directory: datadir =/data/backups/mysql/c. start MySQL service: $/etc/init. d/mysqld start the latter service mysql start is quite simple. as for incremental backup, the directory xtrabackup -- backup -- target-dir =/data/backups/inc1 -- incremental-basedir =/data/backups/base -- datadir =/var must be specified during backup. /lib/mysql/author instancebitsCN.com