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
migrate Simple Press over to new site
Avatar
Charlie Badenhop
Member
Free Members
sp_UserOfflineSmall Offline
Aug 7, 2013 - 8:50 am

We are building a completely new site, but we want to move over the Simple Press plugin and forums (including posts, forum topics, etc.). What would be the best way to do this?

Keep in mind that our new site will not have the same users as the old site does.

 

Thanks.

Avatar
Yellow Swordfish
Glinton, England
SP Master
sp_UserOfflineSmall Offline
Aug 7, 2013 - 10:25 am

The last sentence there makes it a little more difficult.

As a plugin to WordPress SP utilises the WP user base and is built around those users. Normally we would answer this question by saying yes - you can do that but you DO need to take the users and usermeta tables with you as well as the SP tables. because that data is interlinked.

If you do NOT want to take the users with you first then you may have to work out how to re-assign all of the forum posts you already have to 'guest' status. Which can be done with some manually crafted queries..

andy-signature.png
YELLOW
SWORDFISH
Avatar
Charlie Badenhop
Member
Free Members
sp_UserOfflineSmall Offline
Aug 7, 2013 - 10:46 am

Okay, so let's say we wanted to transfer over everything "as is". What would be the steps in doing so? Thanks!

Avatar
Yellow Swordfish
Glinton, England
SP Master
sp_UserOfflineSmall Offline
Aug 7, 2013 - 12:11 pm

Export the forum tables all starting with 'sf' and the WP users and usermeta tables as SQL inserts with DROP TABLE statements included.

Import into your new WP database although make sure the table prefix is the same ion both cases.

Work through the forum options as there will be some URL's that are incorrect.

That is basically it. There will always be a few small tasks to clean things up but I do this and so have many users.

andy-signature.png
YELLOW
SWORDFISH
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: 619
Members: 17361
Moderators: 0
Admins: 4
Forum Stats:
Groups: 7
Forums: 17
Topics: 10127
Posts: 79625