- A+
所属分类:数据库
mysqldump全备 带记录点
1 2 3 4 | if [ ! -d $HOME/backup ];then mkdir -p $HOME/backup cd $HOME/backup fi mysqldump -uroot -p'onlinenongyi&*()' -S /var/lib/mysql/mysql.sock -A --events -B -x --master-data=2|gzip >/server/backup/full/$(date +%F).sql.gz |
分库
1 2 3 4 5 6 7 8 9 10 11 12 13 14 | #!/bin/bash USER=root PASSWD='' PROT=3306 SOCKET=/var/lib/mysql/mysql.sock LOGIN="mysql -u$USER -p$PASSWD -S $SOCKET" DUMP="mysqldump -u$USER -p$PASSWD -S $SOCKET" SHOWDATABASES=$($LOGIN -e "show databases;"|egrep -v "*chema|mysql|test"|sed '1d') DATABASE=${SHOWDATABASES} for da in ${DATABASE} do [ -d /server/backup/$da ] || mkdir -pv /server/backup/$da; $DUMP $da |gzip >/server/backup/${da}/${da}_$(date +%F).sql.gz; done |
分表
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 | #!/bin/bash USER=root PASSWD='' PROT=3306 SOCKET=/var/lib/mysql/mysql.sock MYLOGIN="mysql -u$USER -p$PASSWD -S$SOCKET" MYDUMP="mysqldump -u$USER -p$PASSWD -S$SOCKET" DATEBASE="$($MYLOGIN -e "show databases;"|egrep -vi "Data|_schema|mysql")" for dbname in $DATEBASE do TABLE="$($MYLOGIN -e "use $dbname;show tables;"|sed '1d')" for tname in $TABLE do MYDIR=/server/backup/$dbname/${dbname}_$(date +%F) [ ! -d $MYDIR ] && mkdir -p $MYDIR $MYDUMP $dbname $tname |gzip >$MYDIR/${dbname}_${tname}_$(date +%F).sql.gz done done |

我的微信公众号
我的微信公众号扫一扫