MySQL Innodb Backup

1. Download and install the latest version

http://www.percona.com/downloads/XtraBackup/LATEST/

#For Debian wget http://www.percona.com/downloads/XtraBackup/LATEST/deb/squeeze/x86_64/percona-xtrabackup_2.0.6-521.squeeze_amd64.deb dpkg -i percona-xtrabackup_2.0.6-521.squeeze_amd64.deb #For RedHat wget http://www.percona.com/downloads/XtraBackup/LATEST/RPM/rhel6/x86_64/percona-xtrabackup-2.0.6-521.rhel6.x86_64.rpm yum install percona-xtrabackup-2.0.6-521.rhel6.x86_64.rpm

innobackupex --user=DBUSER --password=DBUSERPASS ${/path_to/BACKUP-DIR}

$ gpg --keyserver hkp://keys.gnupg.net --recv-keys 1C4CBDCDCD2EFD2A ... [some output removed] ... gpg: imported: 1 $ gpg -a --export CD2EFD2A | sudo apt-key add - #Add this to /etc/apt/sources.list, replacing VERSION with the name of your distribution: deb http://repo.percona.com/apt VERSION main deb-src http://repo.percona.com/apt VERSION main #Remember to update the local cache: $ apt-get update

2.

 mysqldump -u DBUSER -p DBNAME DBTABLE > /path/to/DBNAME.DBTABLE.sql

 

( echo "SET AUTOCOMMIT=0;" echo "SET UNIQUE_CHECKS=0;" echo "SET FOREIGN_KEY_CHECKS=0;" cat ${/path/to/DBDATABASE.sql} echo "SET FOREIGN_KEY_CHECKS=1;" echo "SET UNIQUE_CHECKS=1;" echo "SET AUTOCOMMIT=1;" echo "COMMIT;" ) | mysql -u DBUSER -p DBNAME