MySQL Forums
Forum List  »  Newbie

data porting within mysql but 2 different database structures
Posted by: Shahid Sheikh
Date: July 21, 2005 10:18AM

hi guys

Can any1 help me out.

I hv got a mysql 4.0.26 version of mysql running on LAMP environment
(LINUX-RHL3, APACHE1.3, PHP4.2, MYSQL4.0.26)
and hv got 2 database # Db1 & #Db2. ( physically both are on same HDD)

Db1 is the older database with many redundant tables, fields and data.
Db2 is nothing but the same Db1 database where we hv split huge tables into 2 or 3 and hv even added some new tables to it....

NoW problem is DATA PORTING BETWEEN To
FROm
Db1 ================> to =================> Db2.
Do i hv to, manually write the SQL scripts of port the data from 1 table to another, OR is thier a GUI avaialbe from where in i can just map the tables and columns and it would generate the scripts for me...
OR some smart way do it....

do suggest & help
Shahid

Options: ReplyQuote


Subject
Written By
Posted
data porting within mysql but 2 different database structures
July 21, 2005 10:18AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.