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:[EMAIL PROTECTED] Sent: Wednesday, November 17, 2004 4:00 PM To: Adam; [EMAIL PROTECTED]; 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: 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]
