MySQL数据导出

1.      导出在客户端

>mysql -hserver -uname -ppassword -Pport--execute="use test;select * from user " > out.file

耗时180s

 

2.      导出在MySql服务器上

SELECT * INTO OUTFILE 'out.file' from user;

耗时25s