2,导出数据：
mysql> select * from tutorials_tbl -> into outfile '/tmp/tutorials.txt';#导出csv格式mysql> select * from passwd into outfile '/tmp/tutorials.txt' -> fields terminated by ',' enclosed by '' -> lines terminated by '/r/n';
3，导入数据：mysqldump、load data和mysqlimport
#导出$ mysqldump -u root -p tutorials tutorials_tbl > dump.txt#导入$ mysql -u root -p database_name load data local infile 'dump.txt' into table mytbl;mysql> load data local infile 'dump.txt' into table mytbl -> fields terminated by ':' -> lines terminated by '/r/n';mysql>load data local infile 'dump.txt' -> into table mytbl (b, c, a);$ mysqlimport -u root -p --local database_name dump.txt
4，将导出的数据直接导入到远程的服务器
$ mysqldump -u root -p database_name / | mysql -h other-host.com database_name