#! /bin/sh
if [ $# -lt 1 ];then
echo "error.. need args"
exit
fi
if [ "$1"x != "back"x ];then
echo "usage back_db.sh back"
exit
fi
mysqldump -uxxxx -pxxxx db_name>db_name.bak
for dbId in `seq 0 9`
do
mysqldump -uxxxx -pxxxx db_${dbId}>db_${dbId}.bak
done
如何脚本备份各个分库
最新推荐文章于 2023-07-27 20:39:36 发布