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
