Created
February 1, 2012 09:06
-
-
Save ronanguilloux/1716060 to your computer and use it in GitHub Desktop.
Occasional async production mysql bdd backup & local restore
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| ssh prod@server | |
| cd /var/backups/mysql/someDir/ | |
| tar -cjf my_bdd.sql.tar.bz2 my_bdd.sql | |
| exit | |
| cd /tmp | |
| rsync -e ssh -avz prod@server:/var/backups/mysql/someDir/my_bdd.sql.tar.bz2 . | |
| tar -xjf my_bdd.sql.tar.bz2 | |
| mysql -u root -proot my_bdd < my_bdd.sql | |
| rm my_bdd.sql.tar.bz2 my_bdd.sql |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment