实现自动备份表从源库到目标库

#!/bin/bash
user=root
pass=123456
dbFrom=mail
dbTo=analy
echo -e "==================backup old file start====================="
tar -czvf /root/backup/old_files/`date +%F`.tar.gz /root/backup/tables/*
rm -rf /root/backup/tables/*
echo -e "==================backup old file end====================="






echo -e "==================backup start====================="
tables=`mysql -u$user -p"$pass" -e "use $dbFrom;show tables;"|sed 1d`
cat tableName.txt | while read tableName
do
mysqldump -u$user -p"$pass"   -B --databases $dbFrom --tables $tableName > /root/backup/tables/${tableName}-`date +%F`.sql
[ $? -eq 0 ] && echo  $tableName ok >>/root/backup/table.log||echo $tableName failed >>/root/backup/table.log
[ $? -eq 0 ] && echo -e "$tableName ok" ||echo -e "$tableName failed"
done
echo -e "===================backup stop======================="




echo -e "==================import start====================="
for file in /root/backup/tables/*
do
    if test -f $file
    then
        echo import $file 
mysql -u$user -p$pass $dbTo < $file
    else
        echo $file is folder
    fi
done
echo -e "===================import stop======================="