Re: remote mysqldump to csv (--tab)

2010-05-04 Thread walter harms
T 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/selec

Re: remote mysqldump to csv (--tab)

2010-05-04 Thread Marijn Vandevoorde
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 de

RE: remote mysqldump to csv (--tab)

2010-04-28 Thread Carlos Eduardo Caldi
re 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 t

remote mysqldump to csv (--tab)

2010-04-28 Thread Marijn Vandevoorde
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

Re: Remote mysqldump

2002-05-04 Thread Jeremy Zawodny
On Sun, May 05, 2002 at 07:42:13AM +0100, Alexander Shaw wrote: > > Using another machine (running windows) elsewhere on the network, is > it possible to perform a mysqldump of the databases on the server? > i.e. without having to go physically to the server machine and > typing the commands at t

RE: Remote mysqldump

2002-05-04 Thread Alexander Shaw
Paul DuBois wrote "I can think of a couple of different ways to interpret your question. Offhand, I'd say that you want to specify -h server_host on the mysqldump command line, but if that's not what you mean, perhaps you can be more specific." Sorry probably not so well explained, I'll try agai

Re: Remote mysqldump

2002-05-04 Thread Paul DuBois
At 0:27 +0100 5/5/02, Alexander Shaw wrote: >A quick query to save some shoe leather. > >Is it possible to perform a mysqldump from a remote windows client? Is so >how? I can think of a couple of different ways to interpret your question. Offhand, I'd say that you want to specify -h server_host o

Remote mysqldump

2002-05-04 Thread Alexander Shaw
A quick query to save some shoe leather. Is it possible to perform a mysqldump from a remote windows client? Is so how? Have searched the net and MySQL site but have found nothing definitive. Alex --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.co