m: Eve 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,
ECTED]; 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
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,
TED]
Sent: 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 ',' OPTION
;@'%' (Using password: YES)
...even though I am logged 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 c
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 clie
I'm not sure how best to proceed in dumping data from 1 database and getting
a copy of the export, in order to transfer it to another server. I usually
use phpmyadmin to do an export, which nicely creates a .zip file of
everything. I managed to get it connected with Mysql Control Center, but am
no
