Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- #!/bin/bash
- SLAVE_DB_USER="foo"
- SLAVE_DB_PASS="bar"
- SLAVE_DB_NAME="foobar"
- SLAVE_DB_HOST="127.0.0.1"
- MASTER_DB_USER="production_foo"
- MASTER_DB_PASS="foobarbaz"
- MASTER_DB_NAME="production"
- MASTER_DB_HOST="realdomain.com"
- REPLACE_FILE=$SLAVE_DB_NAME.sql
- REPLACED_FILE=$SLAVE_DB_NAME.replace.sql
- # Backup Current DB
- mysqldump --user=$SLAVE_DB_USER --pass=$SLAVE_DB_PASS $SLAVE_DB_NAME > $BACKUP_FILE
- # Get/Replace/Import new DB
- mysqldump --max_allowed_packet=100M --user=$MASTER_DB_USER --pass=$MASTER_DB_PASS --host=$MASTER_DB_HOST $MASTER_DB_NAME > $REPLACE_\
- FILE
- sed -e "s/$MASTER_DB_HOST/$SLAVE_DB_HOST/g" $REPLACE_FILE > $REPLACED_FILE
- mysql --user=$SLAVE_DB_USER --pass=$SLAVE_DB_PASS $SLAVE_DB_NAME -e 'drop database jhankle_accumera; create database jhankle_accumer\
- a;'
- mysql --user=$SLAVE_DB_USER --pass=$SLAVE_DB_PASS $SLAVE_DB_NAME < $REPLACED_FILE
- # Clean up.
- rm $REPLACE_FILE
- rm $REPLACED_FILE
Add Comment
Please, Sign In to add comment