Now that the multi domain plugin is in the works, I would like to merge 3 wpms sites into one and use the multiple domain plugin instead of using 3 separate installs.
Is there a script for this? If not, it should be possible by extracting database tables, renaming them and inserting them creating a new blog-id for users. Anybody tried that?
Now that the multi domain plugin is in the works, I would like to merge 3 wpms sites into one and use the multiple domain plugin instead of using 3 separate installs.
Is there a script for this? If not, it should be possible by extracting database tables, renaming them and inserting them creating a new blog-id for users. Anybody tried that?
6593 pointsLike some sort of WPMU DEV GodExceptionally helpfulLifetime member
Keeper of the Dark Chocolate
—
30th August 2010 (1 year ago)
#
Is there a script for this?
We had a fairly lengthy thread about this eons ago. I'd have to go dig for it although I'm on battery so it'll have to wait until later today. Basically came down to merging to be a bad idea since you could have user accounts overlap and that would be a major problem.
Yes I remember that there was a thread about it. But now WPMU and WP has merged so it could be in more peoples interest to merge several installs into one. I don't know...
I think the only thing that could be a problem is the user ID. But since there is an exporter, maybe it could be done manually. I.e: 1. shut down site. 2. export all blogs. 3. import all blogs. 4. add domain to new site with the multiple domain plugin.
I guess setting the domain could be hard in that scenario, unless you do it blog by blog.
Yeah I guess that's the way to go. But I still believe it would be easier to just merge databases and look for duplicate IDs before doing so. With all the splogs I've had, chances are there won't be many duplicate ID's.
drmike I appreciate your input. I still haven't done this because I'm still not sure how to do it as smooth as possible.
I'm now thinking I will install multi-domain on all 3 sites which will create tables that gives each blog the "right" domain. I will then download 2 of the databases and change blog ID of all blogs. If site1 ends with blog-id 500 I will rename site2's blogs to 501, 502 etc. I will then rename the dir accordingly and add the tables & dirs to site1. I will then do the same with site3.
Do you think that would work?
The export/import option does not import and export the users in a good way. Settings such as theme settings will also be lost. Blog ID's has to be renamed to prevent duplicate entrys.
Responses (6)
Keeper of the Dark Chocolate — 30th August 2010 (1 year ago) #
We had a fairly lengthy thread about this eons ago. I'd have to go dig for it although I'm on battery so it'll have to wait until later today. Basically came down to merging to be a bad idea since you could have user accounts overlap and that would be a major problem.
Member — 30th August 2010 (1 year ago) #
Yes I remember that there was a thread about it. But now WPMU and WP has merged so it could be in more peoples interest to merge several installs into one. I don't know...
I think the only thing that could be a problem is the user ID. But since there is an exporter, maybe it could be done manually. I.e: 1. shut down site. 2. export all blogs. 3. import all blogs. 4. add domain to new site with the multiple domain plugin.
I guess setting the domain could be hard in that scenario, unless you do it blog by blog.
Keeper of the Dark Chocolate — 31st August 2010 (1 year ago) #
Some recent discussion on the topic:
http://wordpress.org/support/topic/merge-several-standalone-installations-into-one-multiuser
Looks like they're recommending it blog by blog over in wp.org land as well.
Member — 2nd September 2010 (1 year ago) #
Yeah I guess that's the way to go. But I still believe it would be easier to just merge databases and look for duplicate IDs before doing so. With all the splogs I've had, chances are there won't be many duplicate ID's.
Member — 8th September 2010 (1 year ago) #
drmike I appreciate your input. I still haven't done this because I'm still not sure how to do it as smooth as possible.
I'm now thinking I will install multi-domain on all 3 sites which will create tables that gives each blog the "right" domain. I will then download 2 of the databases and change blog ID of all blogs. If site1 ends with blog-id 500 I will rename site2's blogs to 501, 502 etc. I will then rename the dir accordingly and add the tables & dirs to site1. I will then do the same with site3.
Do you think that would work?
The export/import option does not import and export the users in a good way. Settings such as theme settings will also be lost. Blog ID's has to be renamed to prevent duplicate entrys.
Member — 10th September 2010 (1 year ago) #
Upping this to see if anybody have any input...
Are there any calls to blog-id inside the database that might mess things up?
Become a member