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