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]

Reply via email to