题目：mysql分库分表备份脚本详细内容[root@db02 scripts]# cat /server/scripts/store_backup.sh #!/bin/sh myuser=root mypass=xuliangwei socket=/data/3306/mysql.sock mylogin=”mysql -u$myuser -p$mypass -s $socket” mydump=”mysqldump -u$myuser -p$mypass -s$socket -b” database=”$($mylogin -e “show databases;”|egrep -vi “data|_schema|mysql”)” for dbname in $database do mydir=/server/backup/$dbname [ ! -d $mydir ] && mkdir -p $mydir $mydump $dbname|gzip >$mydir/${dbname}_$(date +%f).sql.gz done
执行后的结果 [root@db02 /]# tree /server/backup/ /server/backup/ ├── oldboy26 │ ├──oldboy26_2015-12-29.sql.gz │ ├──oldboy26_2015-12-30.sql.gz │ └──oldboy26_2015-12-31.sql.gz ├── oldboy_xuliangwei26 │ ├──oldboy_xuliangwei26_2015-12-29.sql.gz │ ├──oldboy_xuliangwei26_2015-12-30.sql.gz │ └──oldboy_xuliangwei26_2015-12-31.sql.gz └── xuliangwei26 ├──xuliangwei26_2015-12-29.sql.gz ├──xuliangwei26_2015-12-30.sql.gz └── xuliangwei26_2015-12-31.sql.gz 3 directories, 9 files
脚本详细内容 [root@db02 scripts]# cat mysql_table.sh # #!/bin/sh user=root passwd=xuliangwei socket=/data/3306/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
查看执行后的结果 [root@db02 scripts]# tree /server/backup/ /server/backup/ ├── oldboy26 │ ├──oldboy26_2015-12-30 │ │├──oldboy26_oldboy_test_2015-12-30.sql.gz │ │└──oldboy26_oldboy_test2_2015-12-30.sql.gz │ └──oldboy26_2015-12-31 │ ├── oldboy26_oldboy_test_2015-12-31.sql.gz │ └── oldboy26_oldboy_test2_2015-12-31.sql.gz ├── oldboy_xuliangwei26 │ ├──oldboy_xuliangwei26_2015-12-30 │ │├──oldboy_xuliangwei26_cloudstack_2015-12-30.sql.gz │ │├──oldboy_xuliangwei26_dashborad_2015-12-30.sql.gz │ │└── oldboy_xuliangwei26_student_2015-12-30.sql.gz │ └──oldboy_xuliangwei26_2015-12-31 │ ├──oldboy_xuliangwei26_cloudstack_2015-12-31.sql.gz │ ├──oldboy_xuliangwei26_dashborad_2015-12-31.sql.gz │ └──oldboy_xuliangwei26_student_2015-12-31.sql.gz └── xuliangwei26 ├──xuliangwei26_2015-12-30 │├──xuliangwei26_openstack_2015-12-30.sql.gz │├──xuliangwei26_saltstack_2015-12-30.sql.gz │├──xuliangwei26_server_2015-12-30.sql.gz │└──xuliangwei26_zabbix_2015-12-30.sql.gz └──xuliangwei26_2015-12-31 ├──xuliangwei26_openstack_2015-12-31.sql.gz ├──xuliangwei26_saltstack_2015-12-31.sql.gz ├──xuliangwei26_server_2015-12-31.sql.gz └──xuliangwei26_zabbix_2015-12-31.sql.gz 9 directories, 18 files
以上就是mysql怎么实现分库分表备份的详细内容。