开发环境导出

SELECT *
INTO OUTFILE '/var/lib/mysql-files/content_item.csv'
FIELDS TERMINATED BY ','
OPTIONALLY ENCLOSED BY '"'
LINES TERMINATED BY '\n'
FROM content_item;

测试环境导入

LOAD DATA LOCAL INFILE '/var/lib/mysql-files/content_item.csv'
INTO TABLE content_item
FIELDS TERMINATED BY ','
OPTIONALLY ENCLOSED BY '"'
LINES TERMINATED BY '\n';

需要关注权操作用户权限问题