XtraBackup을 이용한 mysql 백업하기 (ubuntu)

$ gpg --keyserver  hkp://keys.gnupg.net --recv-keys 1C4CBDCDCD2EFD2A

$ gpg -a --export CD2EFD2A | sudo apt-key add -

$ sudo vim /etc/apt/sources.list

deb http://repo.percona.com/apt VERSION main
deb-src http://repo.percona.com/apt VERSION main

• 10.04LTS (lucid)
• 12.04LTS (precise)
• 12.10 (quantal)

$ sudo apt-get update

$ sudo apt-get install xtrabackup

$ innobackupex /백업경로

sudo stop mysql

sudo mv /var/lib/mysql /var/lib/mysql-old


sudo mkdir /var/lib/mysql


innobackupex –copy-back /백업경로/년-월-일_시-분-초/


chown -R mysql. /var/lib/mysql