Page 1 of 1

moving data between databases in mysql

Posted: Mon Sep 12, 2005 12:50 pm
by superdude83
hi,
I was wondering what the most efficient way is to move data in tables from one database to the other. If for example I wanted to add new parts of the database, or wanted to change it for some reason..how would I transfer data already in the old database to the new database?

Thanks for the help.

Posted: Mon Sep 12, 2005 1:41 pm
by feyd
export, import.

if your database supports it, you can also do a

Code: Select all

INSERT INTO `database1name`.`table1name` SELECT * FROM `database2name`.`table2name`