mysql跨库转移数据

导出

select * from e into outfile "/data/mysql/e.txt" fields terminated by '|';

注：outfile ‘/path/file’，中的 path 需要有mysql的权限，否则会报错。

导入

load data infile "/data/mysql/e.txt" into table e fields terminated by '|';

注：若数据被某种符号封闭着，需要指定fields enclosed by
举栗子，数据被双引号封闭着

"ZHANGSAN","1010"

load data infile "/data/mysql/e.txt" into table e fields terminated by '|' fields enclosed by '"';

或者使用mysqlimport导入

mysqlimport -u root -pPassword [--local] dbname filename.txt [OPTION]