Support Forum

Advanced Search
Forum Scope


Match



Forum Options



Minimum search word length is 3 characters - maximum search word length is 84 characters
general-topic
Want to migrate my simple:press installation from one wp blog to another...
Avatar
Tao Semko
Member
Free Members
sp_UserOfflineSmall Offline
Jun 20, 2012 - 8:59 am

Can anyone give me insight on how best to migrate my simple:press installation from one wp blog to another (on a different server), keeping all the users, forums, topics intact?

Thank you so much!

Avatar
Yellow Swordfish
Glinton, England
SP Master
sp_UserOfflineSmall Offline
Jun 20, 2012 - 9:21 am

Well you need some of the WP data as well. The users and usermeta tables are required. No others are required unless you have been using the blog linking option. Export those tables (all SP tbales start with the 'sf' prefix) and import into your new database for the new site.

There WILL be some issues. Any embedded links in posts, for example, will point to the old site. You will need to recreate the page for the forum to use. You will need to work thrpough all of your forum settings in case any are not quite right. But many have done this successfully.

andy-signature.png
YELLOW
SWORDFISH
Avatar
Tao Semko
Member
Free Members
sp_UserOfflineSmall Offline
Jun 20, 2012 - 9:36 am

Thank you! 🙂

Avatar
Yellow Swordfish
Glinton, England
SP Master
sp_UserOfflineSmall Offline
Jun 20, 2012 - 10:06 am

Hope it goes well.

andy-signature.png
YELLOW
SWORDFISH
Avatar
Eric Grey
Member
Free Members
sp_UserOfflineSmall Offline
Jun 21, 2012 - 5:19 pm

Hey folks,

I needed this exact information.  Does it matter if Simple Press is at two different versions on the two different servers?

Avatar
Yellow Swordfish
Glinton, England
SP Master
sp_UserOfflineSmall Offline
Jun 21, 2012 - 6:02 pm

As long as the target version is newer than the source then no - bit I wouldn't chance it the other way around

andy-signature.png
YELLOW
SWORDFISH
Avatar
Eric Grey
Member
Free Members
sp_UserOfflineSmall Offline
Jun 21, 2012 - 6:33 pm

Interesting.  It doesn't seem to be working for me.  I've exported the relevant tables, installed Simplepress (newest version) on the target site, import brings users, but not topics/posts.  Any thoughts?  I've deleted everything and tried fresh twice, now.

Avatar
Eric Grey
Member
Free Members
sp_UserOfflineSmall Offline
Jun 21, 2012 - 7:21 pm

Just an update - I did this in every way I could think of... at first I was doing it prior to activation, then after activation.  A couple of notes that may be important - I'm coming from an older version of Simple Press (4.5.1).  I'm hoping to move everything over to my new website.  That website is running Wishlist Member - an installation that was previously integrated with Simple Press.  Simple Press is fully updated on the new server.

All the database tables look normal to me.  However, because Wishlist is there, the wp-users table was already in existence.  Therefore, it resists (mightily) any attempt to upload a duplicate table.  So, I couldn't migrate that data.  However, all the usernames are the same (as they shared the usernames and such with Wishlist).  

Where we stand now is that all the users are correct and imported, settings look normal, but no posts, groups, or anything like that.  Any attempt to put any data in the database is met with some type of "duplicate" error in the database.  I've deleted everything (including database tables) three or four times, tried various configurations of activating and deactivating plugins, and so on.

Nothing seems to help.

In this case, keeping post data is of utmost importance due to my subject matter and the very long, detailed posts that members make. 

If it matters, I've also imported (successfully) all the data into a bbpress installation on the old server.  It's not the "separate site" version, though.

Willing to hear any and all thoughts about this, and happy to provide any more data, files, etc...

Avatar
Yellow Swordfish
Glinton, England
SP Master
sp_UserOfflineSmall Offline
Jun 22, 2012 - 3:48 am

I admit that I rather made the assumption you wanted to move this to a new site - which is what people usually ask for - not an existing one. If you already have users and usermeta data in the target site then that will cause all kinds of issues. The user names are of little importance - the real tie up is in the user IDs.

So this might depend on what other data is already in the target database. Such movements really do need totally empty SP tables on the target and empty user and usermeta tables as well to enable the data relationships to be restored. If that is not going to be possible then those relationships are going to be lost...

andy-signature.png
YELLOW
SWORDFISH
Avatar
Eric Grey
Member
Free Members
sp_UserOfflineSmall Offline
Jun 22, 2012 - 5:25 pm

So, is there any way for me to get my Simple Press forum from my old site to the new one? The user data is, indeed, there. I don't know that I can change that, given the Wishlist member situation.

I would be content, really, even to have an archived version of the posts only - so people could at least access those. It's just really the worst case scenario to lose all of that content, and laboriously copy/pasting seems not only wickedly tedious but also probably not ideal - because we would still lose the user associations.

I hadn't thought it would be so tough! Any solutions out there?

Forum Timezone: Europe/Stockholm
Most Users Ever Online: 1170
Currently Online:
Guest(s) 1
Currently Browsing this Page:
1 Guest(s)
Top Posters:
Mr Papa: 19448
Ike: 2086
Brandon: 864
kvr28: 804
jim: 650
FidoSysop: 577
Conrad_Farlow: 531
fiddlerman: 358
Stefano Prete: 325
Member Stats:
Guest Posters: 620
Members: 17365
Moderators: 0
Admins: 4
Forum Stats:
Groups: 7
Forums: 17
Topics: 10128
Posts: 79626