mysqldump is more like a backup tool and is used to dump the whole table/database rather than select records ...
The workaround we came up with is dump the data to a temp table and then use a python program to convert and dump the table in CSV format. Though it works, I feel it is redundant and not so efficient way of doing things. On Wed, May 19, 2010 at 1:04 PM, Brian Evans <grkni...@scent-team.com>wrote: > 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. > > _______________________________________________ > Mailing list: https://launchpad.net/~maria-discuss > Post to : maria-discuss@lists.launchpad.net > Unsubscribe : https://launchpad.net/~maria-discuss > More help : https://help.launchpad.net/ListHelp >
_______________________________________________ Mailing list: https://launchpad.net/~maria-discuss Post to : maria-discuss@lists.launchpad.net Unsubscribe : https://launchpad.net/~maria-discuss More help : https://help.launchpad.net/ListHelp
