导出
mysqldump -uroot -pxxxx dbname > dbname.sql
导入
mysql -uroot -pxxxx
>source dbname.sql
这样不会出现乱码的问题。 不过bit型会变成tinyint,要手动改回bit(1)
How can I export data in CSV or tab delimited format? Refer
SELECT <fields or *> INTO OUTFILE '/tmp/result.text' FIELDS TERMINATED BY ',' OPTIONALLY ENCLOSED BY '"' LINES TERMINATED BY '/n' FROM <table> WHERE <condition>