I have 2 WordPress sites, A and B. Each of them has users and posts. Now, I want to merge these sites. Points to be noted-

  1. A has 1000 users and 2000 posts. B has 500 users and 3000 posts.

  2. There are some identical users. Say, Rahim and John have accounts on both sites. Rahim wrote 3 posts on A and 2 posts on B. Again, John wrote 0 posts on A and 5 posts on B. On A, user_id of Rahim is 3, on B it's 2. Similarly, John has different user_id on 2 sites.

Am I clear? Now, how can I proceed? I want to keep all the posts to original authors and unify duplicate users.

  • You are clear but I think your question is too board to be answered here, at least for me.
    – cybmeta
    Jan 2 '15 at 11:01
  • So, where should I ask? :(
    – mukto90
    Jan 2 '15 at 11:18
  • Have you tried to export both databases and import them into a local test install? Does it work? What problems are you facing?
    – kaiser
    Jan 2 '15 at 13:53
  • Had you tried native export/import process? In testing environment obviously, I wouldn't try to just run it live. :)
    – Rarst
    Jan 2 '15 at 16:33
  • @Rarst it didn't work. there is an issue regarding primary key in wp_users table. say, both table has user ID 1. as they are primary keys and auto incremental, they can not be merged.
    – mukto90
    Jan 2 '15 at 20:04

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Browse other questions tagged or ask your own question.