1. 导入导出的目录需要mysql用户权限
2. 导出:
SELECT * FROM hs_store.orders INTO OUTFILE 'sss/articles_3.sql' FIELDS TERMINATED BY ',';3. 导入:
LOAD DATA INFILE '/var/lib/mysql/sss/articles_3.sql' INTO TABLE demo.articles FIELDS TERMINATED BY ',' OPTIONALLY ENCLOSED BY '"' LINES TERMINATED BY '\n' (title,created_at,category_id,tag_id,author_id);