数据备份参考1

 

数据库备份一个月之前的，并同步到其他机器。

# cat mysqlbackup.sh

#!/bin/bash

 

passwd='PCegHIFP1bW7S48rQoET'

port=3306

 

deldate=`date -d'-30 day' +'%Y%m%d'`

backdate=`date +'%Y%m%d'`

 

cd /mylnmp/87870_bbs_back/

mysqldump -uroot -p${passwd} --databases bbs_xfgame > ./bbs_xfgame${backdate}.sql

 

tar -zcf bbs_xfgame${backdate}.tar.gz bbs_xfgame${backdate}.sql

 

rm -rf bbs_xfgame${backdate}.sql

 

rm -rf ./bbs_xfgame${deldate}.tar.gz

 

rsync -vrtopg --port=61234 /mylnmp/87870_bbs_back/bbs_xfgame* 42.62.24.233::87870_bbs

============================================================

网站备份一个月之前的并同步到其他机器

# cat wwwroot_back.sh

#!/bin/bash

 

time="$(date +"%Y%m%d")"

date3ago="$(date -d"30 day ago" +"%Y%m%d")"

 

tar cvf /mylnmp/87870_bbs_back/wwwroot_$time.tar.gz /mylnmp/wwwroot

rm -rf /mylnmp/87870_bbs_back/wwwroot_$date3ago.tar.gz

 

rsync -vrtopg --port=61234 /mylnmp/87870_bbs_back/wwwroot* 42.62.24.233::87870_bbs

 

==================================220========================

数据库备份

# cat mysql_bak.sh

#!/bin/bash

 

passwd='6bce8O84m9nEuB5x2oGY'

port=3306

 

deldate=`date -d'-30 day' +'%Y%m%d'`

backdate=`date +'%Y%m%d'`

 

cd /home/data_bak/appbbs.game.87870.com

mysqldump -uroot -p${passwd} --databases appbbs_game > ./appbbs.game_mysql_${backdate}.sql

 

tar -jcvf appbbs.game_mysql_${backdate}.tar.bz2 appbbs.game_mysql_${backdate}.sql

 

rm -rf appbbs.game_mysql_${backdate}.sql

 

rm -rf ./appbbs.game_mysql_${deldate}.tar.bz2

============================================================

网站备份

# cat web_bak.sh

#!/bin/bash

 

time="$(date +"%Y%m%d")"

date3ago="$(date -d"30 day ago" +"%Y%m%d")"

 

tar -jcvf /home/data_bak/appbbs.game.87870.com/web_bak__$time.tar.bz2 /home/wwwroot/appbbs.game.87870.com

rm -rf /home/data_bak/appbbs.game.87870.com/web_bak___$date3ago.tar.gz

 

========================数据库备份===================================

#!/bin/sh

BAKDIR=/data/backup/mysql/`date +%Y-%m-%d`

MYSQLDB=www

MYSQLPW=backup

MYSQLUSR=backup

 

if[ $UID -ne 0 ];then

echo This script must use administrator or root user ,please exit!

sleep 2

exit 0

fi

 

if[ ! -d $BAKDIR ];then

mkdir -p $BAKDIR

else

echo This is $BAKDIR exists ,please exit ….

sleep 2

exit

fi

 

###mysqldump backup mysql

/usr/bin/mysqldump -u$MYSQLUSR -p$MYSQLPW -d $MYSQLDB >/data/backup/mysql/`date +%Y-%m-%d`/www_db.sql

cd $BAKDIR ; tar -czf www_mysql_db.tar.gz *.sql

cd $BAKDIR ;find . -name “*.sql” |xargs rm -rf[ $? -eq 0 ]&&echo “This `date +%Y-%m-%d` RESIN BACKUP is SUCCESS”

cd /data/backup/mysql/ ;find . -mtime +30 |xargs rm -rf

 

备份zabbix表配置

mysqldump -uzabbix -psData#888 --ignore-table=zabbix.history --ignore-table=zabbix.history_log --ignore-table=zabbix.history_str --ignore-table=zabbix.history_text --ignore-table=zabbix.history_uint --ignore-table=zabbix.trends_uint --ignore-table=zabbix.trends --databases zabbix |gzip > /opt/zabbix`date +%Y%m%d`.sql.gz

 

在线备份zabbix数据库【常用】

/usr/local/sdata/mysql/bin/mysqldump -u root -psData#888 --single-transaction --master-data=1 --flush-logs --databases zabbix |gzip > /opt/zabbix`date +%Y%m%d`.sql.gz

 

mysqldump --single-transaction --master-data=1 --flush-logs zabbix > 1.sql

--flush-logs 代表重新刷写另外一个binlog文件

--single-transaction 代表开启事物，不锁表导出

--master-data=2 代表导出的文件头部添加binlog点位信息

 

拷贝复制忽略文件文件夹

#!/bin/bash

date=`date +'%Y%m%d'`

mkdir -p /usr/local/sdata/show-bak-$date

cd /usr/local/sdata/show/

rsync -avrp --exclude 'zabbix' --exclude 'venv' /usr/local/sdata/show/ /usr/local/sdata/show-bak-$date

/usr/local/sdata/mysql/bin/mysqldump -u root -h127.0.0.1 -psData#888 --databases monitor > /usr/local/sdata/show-bak-$date/mysql-bak-$date.sql