Skip to content

Instantly share code, notes, and snippets.

@haisum

haisum/backup-steps.sh

Last active August 17, 2016 08:50
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 haisum/824919031924e40d339c1d4ab506e425 to your computer and use it in GitHub Desktop.
Save haisum/824919031924e40d339c1d4ab506e425 to your computer and use it in GitHub Desktop.
Download ZIP
Backing up and migrating mysql between servers
Raw
backup-steps.sh
/bin/bash -c "innobackupex --stream=tar ./ | gzip -c -1 > /backup/mysql-master-17-08-2016.tar.gz" 2>/backup/mybkp.log
scp backup.tar.gz remoteuser@remotehost:/backup/
cd backup
mkdir mysql-backup
cd mysql-backup
tar -xzif backup.tar.gz
innobackupex --apply-log --use-memory=2G /backup/mysql-backup
service mysql stop
mv /var/lib/mysql /var/lib/mysql-old
mkdir /var/lib/msyql
innobackupex --copy-back /backup/mysql-backup
chown -R mysql:mysql /var/lib/mysql
service mysql start
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment