maria-discuss team mailing list archive
-
maria-discuss team
-
Mailing list archive
-
Message #00165
Re: Please help me clear this simple but critical issue [SELECT INTO OUTFILE LOCAL]
On 5/19/2010 12:58 PM, Cool Guy wrote:
> Sorry for the confusion. We can dump the file to the server where the
> database is hosted but this problem revolves around 2 different
> servers - 1. Client, 2. Database.
>
> So we want to dump the output to the client and MySQL has no such
> implementation. I explored the -e option and specifying the server
> name but it outputs only .txt file and there is no way of specifying
> CSV or pipe-delimited file.
>
> Thank you...
This calls for mysqldump then.
http://dev.mysql.com/doc/refman/5.1/en/mysqldump.html
Other 3rd party clients can do this too.
Follow ups
References