I think for your purpose the best choice in the command line utility mysqldump, which
comes with mysql.
MySQL CC will also let you save the results as a TSV or CSV (this is set in the
preferences somewhere). Use File -> Save -> Save Results from the menu.
-----Original Message-----
From: Eve Atley [mailto:eatley@stripped]
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 the
file!
-----Original Message-----
From: Sergei Skarupo [mailto:SSkarupo@stripped]
Sent: Wednesday, November 17, 2004 4:00 PM
To: Adam; eatley@stripped; 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:lists_acc@stripped]
Sent: Tuesday, November 16, 2004 4:04 PM
To: eatley@stripped; 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. 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 client. Such as Toad for MySQL or MySQL query
browser - see URLs below.
Toad for MySQL
- http://www.toadsoft.com/toadmysql/toad_mysql.htm
MySQL Query Browser:
- http://dev.mysql.com/downloads/query-browser/index.html
Both of these tools will allow you to export a record set as a comma
delimited file.
Good luck!
Regards,
Adam
Eve Atley>
>
> 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 not sure how to dump from this. So I figure I
> can:
>
> A. use a command line (in which case, what commnands should I use to
> dump and export to a file), Or
> B. try to get phpmyadmin to connect (as I'm uncertain how to edit the
config
> file for this),
> Or
> C. learn how to dump from MySql CC (how? I saw no way of handling this
from
> MySQL CC),
> Or
> D. use another GUI client (which one?).
>
> The server in question is mysql.loosefoot.com. Oddly, it was
> connecting fine until my company decided to move to a new server, and
> suddenly, it throws an error that "Connection to database failed:
> Unknown MySQL Server Host 'mysql.loosefoot.com' (0)". I've changed
> *nothing* in my connect script, and as mentioned, I can connect to the
> database via other means.
>
> What would you suggest as the least painful solution?
>
> Thanks,
> Eve
>
>
>
> --
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe:
http://lists.mysql.com/mysql?unsub=1
>
Regards,
Adam
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql?unsub=1
