mysql单表转移数据语句

导出：mysql -h192.168.0.13 -uroot -p --local-infile=1 -D iapppay -e "select * from pay_translog where substr(transtime,1,7) = ‘2013-11‘" > ./pay_translog.txt

导入：/usr/local/mysqlbalance/bin/mysql -uroot -p -P3308 --local-infile=1 -e "LOAD DATA local INFILE ‘/root/pay_translog.txt‘  into table balance.pay_translog character set utf8 fields terminated by ‘\t‘ ;"

本文出自 “我的运维时光” 博客，请务必保留此出处http://aaronsa.blog.51cto.com/5157083/1741500

mysql单表转移数据语句

原文：http://aaronsa.blog.51cto.com/5157083/1741500