← Back to team overview

maria-discuss team mailing list archive

Re: Please help me clear this simple but critical issue [SELECT INTO OUTFILE LOCAL]

 

Oh yeah, I noticed CSV. Is pipe delimited possible too? If yes, this would
solve the problem.

On Wed, May 19, 2010 at 1:38 PM, Brian Evans <grknight@xxxxxxxxxxxxxx>wrote:

>  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>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>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@xxxxxxxxxxxxxxxxxxx
> Unsubscribe : https://launchpad.net/~maria-discuss
> More help   : https://help.launchpad.net/ListHelp
>
>

Follow ups

References