sql导入导出

导出

shell> mysqldump --tab=/tmp db1

mysqldump --tab=/tmp --fields-terminated-by=,
         --fields-enclosed-by='"' --lines-terminated-by=0x0d0a db1

导入

shell

shell> mysql db1 < t1.sql
shell> mysqlimport db1 t1.txt

shell> mysqlimport --fields-terminated-by=,
         --fields-enclosed-by='"' --lines-terminated-by=0x0d0a db1 t1.txt

mysql

mysql> USE db1;
mysql> LOAD DATA INFILE 't1.txt' INTO TABLE t1;

mysql> USE db1;
mysql> LOAD DATA INFILE 't1.txt' INTO TABLE t1
       FIELDS TERMINATED BY ',' FIELDS ENCLOSED BY '"'
       LINES TERMINATED BY '\r\n';

参考：
https://dev.mysql.com/doc/refman/8.0/en/reloading-delimited-text-dumps.html