How to update a new in old sql?

[vineet jain]

Dear Friends, I have two databases of sql.

The old one with some new things and new one with all and lacking the old ones.

I want a new sql database with both the databse united and so that no data is lost.

I dont want to loose the old and nor the new.

the old keep updated daily and so does new one.

Tell me how to merge both.

Thanks

Love and Light

Vineet Jain

I am proud to find this site.!!!

[izzhi]

to unite it, u can choose one database to be the source database, and the other is the new place. do you know phpmyadmin program? u can use it. first, dump the source database into batch file (query file). and then, delete the command "create database bla bla ... ". copy the rest, save as to other file, for example query2.sql

now go to the database u want 2 unite. and then, execute query2.sql. finished, now u get the two database united.

hope u can understand and it works