Linux

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

bayron 2012. 12. 10. 22:40 


$ 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



저작자표시 (새창열림)