mysql 数据库数据同步脚本

172 阅读1分钟

oldifs=$IFS
dump(){
mysqldump   -u${user} -h ${ip}  -P${port}   -p${password}  --opt --skip-lock-tables 

${database} $1 | mysql  -h${ip} -u${user} -P${port} -p${password} -C ${database}
}
dtd(){
        IFS=$oldifs
        arr=($1)
        for table in ${arr[@]}
        do
            echo start dump $table
            dump $table
        done
        IFS=$'\n'
}

IFS=$'\n'

tables="table_1 table_2"


for table in ${tables[@]}
do
        dtd "${table}";

done

IFS=$oldifs