19 May
2010
19 May
'10
7:04 p.m.
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.