存量数据导出导入

一 

1.导出数据

上传查询语句 output.sql 
cd /apps/dbchange/20181204
for i in `seq 1 9` ; do /apps/svr/mysql57/bin/mysql -uroot -p -S /tmp/mysql3306.sock  -D p_f_fa_0$i -N  -e 'source output.sql' > /apps/dbchange/20181204/p_f_fa_0$i.sql; done
for i in `seq 10 32` ; do /apps/svr/mysql57/bin/mysql -uroot -p -S /tmp/mysql3306.sock  -D p_f_fa_$i -N  -e 'source output.sql' > /apps/dbchange/20181204/p_f_fa_$i.sql; done

2.拷贝数据文件到另一台服务器

3.导入数据

cd /apps/dbchange/20181204/
for  i in `seq 1 9` ; do /apps/svr/mysql57/bin/mysql -uroot -p  -S /tmp/mysql3306.sock -D vip_deduct_common -N -e "LOAD DATA LOCAL INFILE '/apps/dbchange/20181204/p_f_fa_0$i.sql' INTO TABLE  bank_card character set utf8 (channel_id,channel_code,user_id,create_time)"; done
for  i in `seq 10 32` ; do /apps/svr/mysql57/bin/mysql -uroot -p  -S /tmp/mysql3306.sock -D vip_deduct_common -N -e "LOAD DATA LOCAL INFILE '/apps/dbchange/20181204/p_f_fa_$i.sql' INTO TABLE  bank_card character set utf8 (channel_id,channel_code,user_id,create_time)"; done

 

二 简单点

/apps/svr/mysql57/bin/mysql -uroot -p -S /tmp/mysql3306.sock -D vip_bi_tmp -e "LOAD DATA LOCAL INFILE '/apps/dbchange/20180927/sql_data.txt' INTO TABLE temp_order_sn fields terminated by ',' "
-- 或者
load data infile '/download/ou1.txt' into table temp_order_sn1 fields terminated by ','