← Back to team overview

maria-discuss team mailing list archive

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

 

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.
>
>     _______________________________________________
>     Mailing list: https://launchpad.net/~maria-discuss
>     <https://launchpad.net/%7Emaria-discuss>
>     Post to     : maria-discuss@xxxxxxxxxxxxxxxxxxx
>     <mailto:maria-discuss@xxxxxxxxxxxxxxxxxxx>
>     Unsubscribe : https://launchpad.net/~maria-discuss
>     <https://launchpad.net/%7Emaria-discuss>
>     More help   : https://help.launchpad.net/ListHelp
>
>


Follow ups

References