maria-discuss team mailing list archive
Mailing list archive
Re: Please help me clear this simple but critical issue [SELECT INTO OUTFILE LOCAL]
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!
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.
>> Other 3rd party clients can do this too.
>> Mailing list: https://launchpad.net/~maria-discuss<https://launchpad.net/%7Emaria-discuss>
>> Post to : maria-discuss@xxxxxxxxxxxxxxxxxxx
>> 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@xxxxxxxxxxxxxxxxxxx
> Unsubscribe : https://launchpad.net/~maria-discuss
> More help : https://help.launchpad.net/ListHelp