MySQL导出数据及导入数据中文乱码

1.文件要与数据库表的编码保持一致；

2.导入时指定编码

（1）csv：LOAD DATA LOCAL INFILE 'C:\mytable.csv' INTO TABLE `mytable` character set utf8 FIELDS TERMINATED BY ',' ESCAPED BY '\' LINES TERMINATED BY ' '

（2）SQL文件：

load data local infile 'c:\mytable.sql'  into table `mytable`　character set utf8;

导出数据：

select * from mytable [where] into outfile 'c:\mytalbe.sql';