[thelist] MySQL, copy between databases

[Ken Moore]

Hi all,

Is there any way to copy records between databases without exporting and
then importing?

Example:

In database db1, there is a table called db1_table1. In database db2, there
is an identical table called db2_table1. I want to copy records from table
db1_table1 to db2_table2.

Any ideas?

TIA (Thanx in advance).

Respectfully,

Ken Moore
ken at abqnets.com