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 > _________________________________________________________________ O Internet Explorer 8 quer te ajudar a navegar seguro. Entre aqui para ler as dicas. http://www.microsoft.com/brasil/windows/internet-explorer/?WT.mc_id=1500
