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' ;"

     本文轉自aaron428 51CTO部落格，原文連結：http://blog.51cto.com/aaronsa/1741500，如需轉載請自行聯系原作者