On 5/19/2010 1:12 PM, Cool Guy wrote:
> 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 second thought, you CAN use the mysql -e IF you do this (as an example):
mysql -u root -p -Nsr -e "SELECT
CONCAT('\"',FirstName,'\",\"',LastName,'\"') from db.users"
Change to suit.
>
> On Wed, May 19, 2010 at 1:04 PM, Brian Evans <grkni...@scent-team.com
> <mailto: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
> <https://launchpad.net/%7Emaria-discuss>
> Post to : maria-discuss@lists.launchpad.net
> <mailto:maria-discuss@lists.launchpad.net>
> Unsubscribe : https://launchpad.net/~maria-discuss
> <https://launchpad.net/%7Emaria-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
