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:
Hi
You can use on shell, connect at the client mysq -h (host or IP)
-p(password)
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
http://dev.mysql.com/doc/refman/5.0/en/select-into-statement.html
Carlos Caldi
> Date: Wed, 28 Apr 2010 14:11:14 +0200
> From: ma...@psb.vib-ugent.be
> To: mysql@lists.mysql.com
> 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
remotely,
> on the client where mysqldump is executed.
> I've been looking up and down, only to find bad news, so I'm pretty
sure
> 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
just
> 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=ce_ca...@hotmail.com
>
------------------------------------------------------------------------
Cansado de entrar em todas as suas diferentes contas de email? Veja
como juntar todas
<http://www.windowslive.com.br/public/tip.aspx/view/16?product=1&ocid=Hotmail:MSN:Hotmail:Tagline:1x1:semLinha>
--
Marijn Vandevoorde
Tel:+32 (0)9 331 36 95 fax:+32 (0)9 3313809
VIB Department of Plant Systems Biology, Ghent University
Technologiepark 927, 9052 Gent, BELGIUM
marijn.vandevoo...@psb.vib-ugent.be http://www.psb.vib-ugent.be
==================================================================
"You're so beautiful.You could be a part time model.
But you'd probably still have to keep your normal job"
--J. Clement
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql?unsub=arch...@jab.org
