into outfile 数据备份及还原

一：备份
SELECT * FROM mds_ca_user INTO OUTFILE '/tmp/s.txt'
注释：默认数据之间用tab；记录自成一行
SELECT * FROM mds_ca_user INTO OUTFILE '/tmp/9.txt' FIELDS TERMINATED BY ',' OPTIONALLY ENCLOSED BY '"' LINES TERMINATED BY '\n';
注释：即使用,分割字段，双引号限定字段内容，\n分割记录。
二：还原
默认情况：
LOAD DATA INFILE '/tmp/9.txt' INTO TABLE mds_ca_user

默认情况：
LOAD DATA INFILE '/tmp/9.txt' INTO TABLE mds_ca_user
但是有字符分割是
LOAD DATA INFILE '/tmp/9.txt' INTO TABLE mds_ca_user FIELDS TERMINATED BY ',' OPTIONALLY ENCLOSED BY '"' LINES TERMINATED BY '\n';