1. #!/bin/sh
    2. ###
    3. #mysql hosts
    4. #Host="x.x.x.x"
    6. #从键盘获取mysql HOSTS
    7. echo -n "Enter your Host:"
    8. read Host
    10. #从键盘获取mysql User
    11. echo -n "Enter your User:"
    12. read User
    14. #从键盘获取mysql Pass
    15. echo -n "Enter your Pass:"
    16. read Pass
    18. #从键盘获取mysql Port
    19. echo -n "Enter your Port:"
    20. read Port
    22. #获取mysql库
    23. database=`mysql -h ${Host} -u${User} -p$Pass -P$Port -e "show databases;"|grep -v "Database"|grep -v "information_schema"|grep -v "performance_schema"|grep -v "mysql"|grep -v "sys"`
    25. #创建存放库表的目录
    26. mkdir /root/tuku && cd /root/tuku && mkdir -p $database table
    28. #获取表文件
    29. for ku in $database;do echo `mysql -h ${Host} -u${User} -p$Pass -P$Port -e "use $ku;show tables;"|grep -v "Tables_in*"` >/root/tuku/table/$ku;done
    31. #开始下载
    32. for i in `ls /root/tuku/table`;do for j in `cat /root/tuku/table/$i`;do mysql -h ${Host} -u${User} -p$Pass -P$Port -e "select * from $i.$j;" >/root/tuku/$i/$i.$j.txt;done;done
    34. #或者直接备份成sql，再到自己数据库恢复：
    35. #mysqldump -h$Host -uroot -p$Pass  --all-databases > /root/aa.sql