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 <[email protected] > <mailto:[email protected]>> 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 >> <[email protected] <mailto:[email protected]>> 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 : [email protected] Unsubscribe : https://launchpad.net/~maria-discuss More help : https://help.launchpad.net/ListHelp
