MySQL 分库备份脚本
分库备份的实战脚本
#!/bin/bash
TIME=`date +%F_%H-%M-%S`
DIR=/backup
PASS=magedu
[ -d "$DIR" ] || mkdir $DIR
for db in `mysql -uroot -p "$PASS" -e ‘show databases‘ | grep -Ev
‘^(Database|information_schema|performance_schema)$‘`;do
mysqldump -F --single-transaction --master-data=2 -q -B $db | gzip > ${DIR}/${db}_${TIME}.sql.gz
done
相关推荐
CoderToy 2020-11-16
emmm00 2020-11-17
王艺强 2020-11-17
ribavnu 2020-11-16
bianruifeng 2020-11-16
wangshuangbao 2020-11-13
苏康申 2020-11-13
vivenwan 2020-11-13
moyekongling 2020-11-13
云中舞步 2020-11-12
要啥自行车一把梭 2020-11-12
aydh 2020-11-12
kuwoyinlehe 2020-11-12
minerk 2020-11-12
vitasfly 2020-11-12
jazywoo在路上 2020-11-11
敏敏张 2020-11-11
世樹 2020-11-11