[thelist] MySQL, copy between databases?

[Hassan Schroeder]

Ken Moore wrote:

 > 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.

Depends -- is this a one-time deal, or?

For a complete copy to start out with --

CREATE TABLE IF NOT EXISTS db2.table2 SELECT * FROM db1.table1

   /* assuming you have the proper permissions on both DBs */

What you do after that depends on the needs of your application(s) :-)

-- 
Hassan Schroeder ----------------------------- hassan at webtuitive.com
Webtuitive Design ===  (+1) 408-938-0567   === http://webtuitive.com

                           dream.  code.