maria-discuss team mailing list archive

[Brian Evans <grknight@xxxxxxxxxxxxxx>]

On 5/19/2010 1:32 PM, Cool Guy wrote:
> Yep, but the only problem is the inability to dump it as pipe or CSV
> format - in other words, we don't have any flexibility at all in the
> way of formatting the out file. 
>
> Thanks for the continued super quick replies!

My example dumps to CSV if you looked at it closely.
The CONCAT does the format and the -Nsr gets rid of the table-like
structure.

Brian
>
> On Wed, May 19, 2010 at 1:27 PM, Brian Evans <grknight@xxxxxxxxxxxxxx
> <mailto:grknight@xxxxxxxxxxxxxx>> wrote:
>
>     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
>>     <grknight@xxxxxxxxxxxxxx <mailto:grknight@xxxxxxxxxxxxxx>> 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.
>>