you can circumvent the problem by using stdout.
just drop the "INTO OUTFILE '/tmp/result.txt'".
the result should look something like that:
mysql -BAN <database> -e "select ..." >filename
you can also pipe truh gzip to compress the file and save
a lot of space.
note: i found ";" is not a good separator since people
may use ; in comments, i prefer "|" for that reason.
Marijn Vandevoorde schrieb:
> Thank you for replying Carlos, but I'm under the impression that this
> will also put the file on the server. Acutally, mysqldump --tab uses
> INTO OUTFILE to generate the dump if i'm not mistaken
> Carlos Eduardo Caldi wrote:
>> You can use on shell, connect at the client mysq -h (host or IP)
>> and run the query:
>> SELECT a, b, c INTO OUTFILE '/tmp/result.txt'
>> FIELDS TERMINATED BY ';' OPTIONALLY ENCLOSED BY '"'
>> LINES TERMINATED BY '\n'
>> FROM test_table
>> more info see the link
>> Carlos Caldi
>> > Date: Wed, 28 Apr 2010 14:11:14 +0200
>> > From: mavoo@stripped
>> > To: mysql@stripped
>> > Subject: remote mysqldump to csv (--tab)
>> > Hi all,
>> > posted this in the backup list, but that one seems to be pretty
>> dead, so i'll try my luck again here:
>> > We're currently looking for a way to backup a pretty big mysql table to
>> > a csv file. However, we don't want to allow the user ssh or file access
>> > to the server, so it'd have to happen remotely. the --tab/-T option
>> > allows exporting to csv, but not remotely.
>> > So we're looking for a way to have mysqldump store these files
>> > on the client where mysqldump is executed.
>> > I've been looking up and down, only to find bad news, so I'm pretty
>> > it's just not possible. I know there are ways to do this (little script
>> > to convert the sql to csv, or pipe it all through sed), but we were
>> > wondering if we're really not overlooking a nifty option in
>> mysqldump :-)
>> > Thanks in advance
>> > mavoo
>> > --
>> > MySQL General Mailing List
>> > For list archives: http://lists.mysql.com/mysql
>> > To unsubscribe: http://lists.mysql.com/mysql?unsub=1
>> Cansado de entrar em todas as suas diferentes contas de email? Veja
>> como juntar todas