Mysql синхронизация баз
#!/bin/bash
LOGIN=backup
PASS=PASS
HOST=31.23.23.23
BASE=mikbill
HOME_DIR=$(cd $(dirname $0)&& pwd)
PATH_MIKBILL=/var/www/mikbill/admin/
DB_USER=$(cat $PATH_MIKBILL'app/etc/config.xml'| grep username | awk '{ gsub("<username>"," "); print }' | awk '{ gsub("</username>"," "); print }' | awk '{print $1}')
DB_PASSWORD=$(cat $PATH_MIKBILL'app/etc/config.xml'| grep password | awk '{ gsub("<password>"," "); print }' | awk '{ gsub("</password>"," "); print }' | awk '{print $1}')
rm -f HOME_DIR/$BASE.sql
mysqldump -u$LOGIN -h$HOST -p$PASS $BASE > $HOME_DIR/$BASE.sql
mysql -u$DB_USER -p$DB_PASSWORD mikbill < $HOME_DIR/$BASE.sql
Еще скрипт
#!/bin/bash
LOGIN=backup
PASS=PASS
HOST=31.31.31.31
BASE=mikbill
HOME_DIR=$(cd $(dirname $0)&& pwd)
PATH_MIKBILL=/var/www/mikbill/admin/
DB_USER=$(cat $PATH_MIKBILL'app/etc/config.xml'| grep username | awk '{ gsub("<username>"," "); print }' | awk '{ gsub("</username>"," "); print }' | awk '{print $1}')
DB_PASSWORD=$(cat $PATH_MIKBILL'app/etc/config.xml'| grep password | awk '{ gsub("<password>"," "); print }' | awk '{ gsub("</password>"," "); print }' | awk '{print $1}')
#rm -f HOME_DIR/$BASE.sql
#mysqldump -u$LOGIN -h$HOST -p$PASS $BASE > $HOME_DIR/$BASE.sql
#mysql -u$DB_USER -p$DB_PASSWORD mikbill < $HOME_DIR/$BASE.sql
FILENAME=backup_xM8Op234234O34L5r.sql.gz
rm -f $HOME_DIR/$FILENAME
wget -P $HOME_DIR http://$HOST/$FILENAME
gunzip < $HOME_DIR/$FILENAME | mysql -u$DB_USER -p$DB_PASSWORD mikbill
LOGIN=backup
PASS=PASS
HOST=31.23.23.23
BASE=mikbill
HOME_DIR=$(cd $(dirname $0)&& pwd)
PATH_MIKBILL=/var/www/mikbill/admin/
DB_USER=$(cat $PATH_MIKBILL'app/etc/config.xml'| grep username | awk '{ gsub("<username>"," "); print }' | awk '{ gsub("</username>"," "); print }' | awk '{print $1}')
DB_PASSWORD=$(cat $PATH_MIKBILL'app/etc/config.xml'| grep password | awk '{ gsub("<password>"," "); print }' | awk '{ gsub("</password>"," "); print }' | awk '{print $1}')
rm -f HOME_DIR/$BASE.sql
mysqldump -u$LOGIN -h$HOST -p$PASS $BASE > $HOME_DIR/$BASE.sql
mysql -u$DB_USER -p$DB_PASSWORD mikbill < $HOME_DIR/$BASE.sql
Еще скрипт
#!/bin/bash
LOGIN=backup
PASS=PASS
HOST=31.31.31.31
BASE=mikbill
HOME_DIR=$(cd $(dirname $0)&& pwd)
PATH_MIKBILL=/var/www/mikbill/admin/
DB_USER=$(cat $PATH_MIKBILL'app/etc/config.xml'| grep username | awk '{ gsub("<username>"," "); print }' | awk '{ gsub("</username>"," "); print }' | awk '{print $1}')
DB_PASSWORD=$(cat $PATH_MIKBILL'app/etc/config.xml'| grep password | awk '{ gsub("<password>"," "); print }' | awk '{ gsub("</password>"," "); print }' | awk '{print $1}')
#rm -f HOME_DIR/$BASE.sql
#mysqldump -u$LOGIN -h$HOST -p$PASS $BASE > $HOME_DIR/$BASE.sql
#mysql -u$DB_USER -p$DB_PASSWORD mikbill < $HOME_DIR/$BASE.sql
FILENAME=backup_xM8Op234234O34L5r.sql.gz
rm -f $HOME_DIR/$FILENAME
wget -P $HOME_DIR http://$HOST/$FILENAME
gunzip < $HOME_DIR/$FILENAME | mysql -u$DB_USER -p$DB_PASSWORD mikbill
Скрипт восстановления с резервного на основной:
#!/bin/bash
LOGIN=backup
PASS=PASS
HOST=31.32.32.32
BASE=mikbill
HOME_DIR=$(cd $(dirname $0)&& pwd)
PATH_MIKBILL=/var/www/mikbill/admin/
DB_USER=$(cat $PATH_MIKBILL'app/etc/config.xml'| grep username | awk '{ gsub("<username>"," "); print }' | awk '{ gsub("</username>"," "); print }' | awk '{print $1}')
DB_PASSWORD=$(cat $PATH_MIKBILL'app/etc/config.xml'| grep password | awk '{ gsub("<password>"," "); print }' | awk '{ gsub("</password>"," "); print }' | awk '{print $1}')
sudo mysqldump -u$DB_USER -p$DB_PASSWORD $BASE | mysql -u$BACKUP -h $HOST -p$PASS $BASE
Комментарии
Отправить комментарий