mysql backup instructions debian squeeze

backup

$ sudo innobackupex --user=USER --password=PASSWORD PATH_TO_BACKUP_DIR 

prepare

$sudo innobackupex --apply-log --use-memory=1GB PATH_TO_BACKUP_DIR

restore

$ sudo service mysql stop                                                   
$ sudo mv /var/lib/mysql /var/lib/mysql.old                           
$ sudo innobackupex --copy-back PATH_TO_BACKUP_DIR
$ sudo chown -R mysql:mysql /var/lib/mysql
$ sudo service mysql start
    
    

xtrackbackup_install.sh

#!/usr/bin/env bash

DIR='xtrackbackup'
mkdir $DIR && cd $DIR
apt-get -y update
apt-get -y install libaio1
wget http://www.percona.com/redir/downloads/XtraBackup/LATEST/deb/squeeze/x86_64/percona-xtrabackup_2.0.7-552.squeeze_amd64.deb
dpkg -i percona-xtrabackup_2.0.7-552.squeeze_amd64.deb

echo "COMPLETED"