Skip to content

Instantly share code, notes, and snippets.

@sandys

sandys/innobackupex.sh

Last active September 16, 2015 14:43
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save sandys/5a726245e45487b4ba5e to your computer and use it in GitHub Desktop.
Save sandys/5a726245e45487b4ba5e to your computer and use it in GitHub Desktop.
Download ZIP
innobackup working
Raw
innobackupex.sh
#source
innobackupex --user=root --password=root /www/DB-BACKUP
#destination
scp root@server:/www/DB-BACKUP /tmp
innobackupex --apply-log --ibbackup=xtrabackup /tmp/DB-BACKUP/2015-09-16_12-05-39/
innobackupex --copy-back /tmp/DB-BACKUP/2015-09-16_12-05-39/
rm /var/lib/mysql-new/ib_logfile1
rm /var/lib/mysql-new/ib_logfile0
aptitude install php5-curl unzip git xtrabackup mysql-server mysql-client nginx php5-fpm php5-xcache php5-mysql
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment