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
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