Mobile app version of vmapp.org
Login or Join
Reiling115

: I want to combine the databases from two different sites under one URL. How is this possible? I have a small site that I want to merge with a bigger one. Both on Wordpress. How can I

@Reiling115

Posted in: #Database

I have a small site that I want to merge with a bigger one. Both on Wordpress. How can I merge the second one with the first?

I know that one solution would be to make the smaller one a subdomain of the bigger one, but I would like the following thing to happen: when I click on a category or a tag, posts from both sites/databases would appear. Something like Smashing Magazine did when it assimilated designinformer.com.

The other solution and the one that I would prefer would be to merge the two databases, but I don't know if this is possible.

10.01% popularity Vote Up Vote Down


Login to follow query

More posts by @Reiling115

1 Comments

Sorted by latest first Latest Oldest Best

 

@Gretchen104

when I click on a category or a tag, posts from both sites/databases would appear


The easiest thing to do would be to export the content from Site 2 - the built-in exporter should be good enough for this - and then import it into Site 1. That should bring in the content without too many overall issues.

The things you will need to be careful about are:


Permalinks. Make sure both sites are using the same permalink pattern before merging.
Categories/Tags. To be safe, make sure Site 1 and Site 2 have the same taxonomies
Broken links. Some internal links on the Site 2 content will most likely break during import. You will need to run a search and replace on the database and replace all instances of site2.com with site1.com
Custom Functionality. If Site 2 has Custom Post Types or content is otherwise dependent on a plugin or custom functions, make sure those are replicated on Site before the import.


I strongly suggest creating a test version of Site 1 (if you don't have one already) and running a test import :)

10% popularity Vote Up Vote Down


Back to top | Use Dark Theme