MySql数据库备份

脚本如下

#! /bin/bash
time2=$(date "+%Y-%m-%d-%H-%M-%S")
path="/back/db/$time2"

if [ ! -d "$path" ]; then
 mkdir -p "$path"
fi


mysqldump -h 127.0.0.1 -uroot1 -ppassword dbname tablename --set-gtid-purged=off > "$path/u_balance.sql"

mysqldump -h 127.0.0.1 -uroot1 -ppassword dbname tablename --set-gtid-purged=off > "$path/u_trade_detail.sql"

mysqldump -h 127.0.0.1 -uroot1 -ppassword dbname tablename --set-gtid-purged=off > "$path/u_trade_entrust.sql"