1. 导出至文件方法:
(1)导出至CSV文件: select * from video into outfile "/tmp/tmp.csv" fields terminated by ",";
(2)-e 执行sql > a.sql
(3)mysqldump -u -p dev_taisan video > a.sql
2. 从文件导入方法:
(1) mysql -uroot dev_taisan < a.sql
1. 导出至文件方法:
(1)导出至CSV文件: select * from video into outfile "/tmp/tmp.csv" fields terminated by ",";
(2)-e 执行sql > a.sql
(3)mysqldump -u -p dev_taisan video > a.sql
2. 从文件导入方法:
(1) mysql -uroot dev_taisan < a.sql