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 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/[EMAIL PROTECTED] > Regards, Adam -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]