Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations IamaSherpa on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Is it possible to merge two SQL tables

Status
Not open for further replies.

jfambrini

Technical User
Jan 28, 2012
1
Hello:
I have two Joomla sites and I would like to import selected fields from Site 1 to Site 2 via my SQL (phpmyadmin). I want to keep all fields and records of Site 2 but import additional fields and records from Site 1. Both of these are automotive sites. Site 1 has almost all major auto brands and different vehicle models

- Site 1 is already well developed and has well defined menu items and defined categories, sections and content.
- Site 2 needs to have the same menu items and the same content as Site 1 but I cannot do a wholesale import via PhpMyAdmin as I want to preserve specific menu items and its content that are not in the first site.
- I would like a program to only add unique content from sql dump of site 1 to sql file of the 2nd site without touching the existing database.

Is there a way to compare the two sql files and then only add unique content from one site to another?

Thanks,
Regards,
John
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top