导数据和同步数据脚步

越来越懒了，根据公司业务写了一个导如MySQL数据库数据的脚步，第一个是导入数据，第二个是将公网一个表同步到本地局域网。

 

 

 

#!/bin/bash #Creation Date:2010-8-6 #Author:wubolu read -p "Please inupt filename:" filename if test -f /tmp/$filename;then echo "Please wait ..." /usr/local/mysql/bin/mysql -u NAME --password='PASSWORD' << EOFMYSQL use gk2010; truncate table lq; set names utf8; load data infile '/tmp/$filename' into table gk2010.lq fields terminated by ',' enclosed by '"' lines terminated by '\r\n' ignore 1 lines; update lq,cj set lq.csny=cj.csny where lq.zkzh=cj.zkzh; quit; EOFMYSQL echo -e \\n +-------------------------------------------------------+ echo " Done, thank you for choosing wubolu's shell script!" echo -e +-------------------------------------------------------+\\n else echo "/tmp/$filename  No such file." fi exit 0

 

 

（以下脚步运行前提是建立两服务器间通信免密码信任，具体设置请看 http://wubolu.iteye.com/blog/707572 ）

 

#!/bin/bash #Creation Date:2010-8-6 #Author:wubolu rm -rf /usr/local/mysql/data/gk2010/lq.*; scp -C root@125.88.108.81:/usr/local/mysql/var/gk2010/lq .* /usr/local/mysql/data/gk2010/; chown mysql:mysql /usr/local/mysql/data/gk2010/lq.*; /usr/local/mysql/bin/mysql -u NAME --password='PASSWORD' << EOFMYSQL use gk2010; flush table lq; EOFMYSQL echo -e \\n +-------------------------------------------------------+ echo "|  Done, thank you for choosing wubolu's shell script!      |" echo -e +-------------------------------------------------------+\\n