On Mon, 10 Mar 2008, Daniel Brown <parasane@gmail.com> wrote:
> On Mon, Mar 10, 2008 at 2:58 PM, skills2go
> <support@renoandrealestate.com> wrote:
>> I'm trying to copy a database table form one database to another
>> on a different server. Is it possible through myphpadmin, or do I
>> need software? If software, do you know of any good programs to
>> do this?
>
> The same question just received an excellent answer from Rolando
>Edwards about ten minutes ago. Check the archive here:
>
>
> http://marc.info/?l=mysql&m=120517563300467&w=2

The one missing piece: mysqldump can choose to dump only one or a few
databases, and if given one database name, can dump only selected
tables. <http://dev.mysql.com/doc/refman/5.0/en/mysqldump.html>:

There are three general ways to invoke mysqldump:

shell> mysqldump [options] db_name [tables]
shell> mysqldump [options] --databases db_name1 [db_name2 db_name3...]
shell> mysqldump [options] --all-databases

Read the manual for your version of MySQL for more options.
--opt looks like it might be most useful.

--
Tim McDaniel, tmcd@panix.com