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.
moving data between databases in mysql
Moderator: General Moderators
-
superdude83
- Forum Newbie
- Posts: 2
- Joined: Mon Sep 12, 2005 12:38 pm
- feyd
- Neighborhood Spidermoddy
- Posts: 31559
- Joined: Mon Mar 29, 2004 3:24 pm
- Location: Bothell, Washington, USA
export, import.
if your database supports it, you can also do a
if your database supports it, you can also do a
Code: Select all
INSERT INTO `database1name`.`table1name` SELECT * FROM `database2name`.`table2name`