data porting within mysql but 2 different database structures
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
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.