Re: Merge two Databases into one

Larry's right, if it's a one time thing, use mysqldump -u YOUR_DB_USER -p OLD_DB --no-create-info > SOME_FILE.sql from the command line. Then, to import, use: mysqlimport -u YOUR_DB_USER -p NEW_DB SOME_FILE.sql To be sure you understand what's happening, check the docs first: http://dev.mysql.c

Re: Merge two Databases into one

On Fri, Oct 24, 2014 at 1:17 PM, Ram Ganesh wrote: > Hi all, > > I want to append my datas from old_db to new_db > they have exactly the same structure, > > I'm trying to Write a Script using Django Manually selecting a database > -Read data from old_db and Write it into new_db > -But not sure

Merge two Databases into one

Hi all, I want to append my datas from old_db to new_db they have exactly the same structure, I'm trying to Write a Script using Django Manually selecting a database -Read data from old_db and Write it into new_db -But not sure its work fine with maintaining foreign key relationships. what