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