Mysql数据迁移

实现的功能    将一台服务器上的Mysql数据  使用CSV 转移到另一台服务器上去数据

之前使用 发现 数据字段的格式不同 会导致 导入失败   （只会导出 或  导入在本机电脑上面）

导出
select * from td_lzda_file
into outfile 'C:/csv1/td_lzda_file.csv'
fields terminated by ',' optionally enclosed by '"' escaped by '"'
lines terminated by '\r\n'



导入
load data infile 'C:/csv1/td_lzda_file.csv'
into table td_lzda_file
fields terminated by ',' optionally enclosed by '"' escaped by '"'
lines terminated by '\r\n';

改成 下面之中可以正常导入了

导出
select * from td_lzda_file into outfile 'C:/csv4/td_lzda_file.csv' 
CHARACTER SET 'utf8' 
fields terminated by ',' 
enclosed by ""

导入
load data infile 'C:/csv4/td_lzda_file.csv' into table td_lzda_file CHARACTER SET 'utf8' fields  terminated by ',' enclosed by ""