in via the client.
-Original Message-
From: Adam [mailto:[EMAIL PROTECTED]
Sent: Tuesday, November 16, 2004 7:04 PM
To: [EMAIL PROTECTED]; MySQL General
Subject: Re: Trying to dump from GUI client
Eve,
From the command line you can use `mysql`, command line tool that ships
with
MySQL
: Wednesday, November 17, 2004 12:14 PM
To: 'Adam'; 'MySQL General'
Subject: RE: Trying to dump from GUI client
I am trying MySQL Query Browser, but I get this error...
SELECT * INTO OUTFILE 'c:\temp\candidate.txt'
FIELDS TERMINATED BY ',' OPTIONALLY ENCLOSED BY ''
LINES TERMINATED BY '\n'
FROM
If I remember correctly, with select into outfile the outfile has to be on
the server.
-Original Message-
From: Adam [mailto:[EMAIL PROTECTED]
Sent: Tuesday, November 16, 2004 4:04 PM
To: [EMAIL PROTECTED]; MySQL General
Subject: Re: Trying to dump from GUI client
Eve,
From
]; MySQL General
Subject: RE: Trying to dump from GUI client
If I remember correctly, with select into outfile the outfile has to be on
the server.
-Original Message-
From: Adam [mailto:[EMAIL PROTECTED]
Sent: Tuesday, November 16, 2004 4:04 PM
To: [EMAIL PROTECTED]; MySQL General
Subject: Re
Atley [mailto:[EMAIL PROTECTED]
Sent: Wednesday, November 17, 2004 2:13 PM
To: Sergei Skarupo; 'Adam'; 'MySQL General'
Subject: RE: Trying to dump from GUI client
Alright, using TOAD, I managed to get my data into CSV. When using
PHPMYADMIN to load into another database, it tells me it can't read
Eve,
From the command line you can use `mysql`, command line tool that ships with
MySQL. You would want to use the
SELECT ... INTO OUTFILE 'file.txt' FROM ...;
See the MySQL manual for more information on this:
- http://dev.mysql.com/doc/mysql/en/SELECT.html
You can use another MySQL