Support Forum

Ike said

The database is a table of information, so in this case users, posts, forums etc.. The SP data you would be looking to move is stored in the database in SP specific tables starting with the prefix 'sf'.

You would need to export your SP database using the method detailed in the link of post #4.

If you need to move your WordPress and Simple:Press installation to a new server
Simply ensure that all of the Simple:Press database tables are moved alongside those of your core WordPress. The Simple:Press tables are all prefixed with ‘sf‘ (following your own database level table prefix).

Be aware that some WordPress plugins we have looked at in the past that offer to perform some of these tasks will only operate on the core WordPress tables. Simply ensure that ALL tables are included in the move and there should be no other tasks to be carried out.

OK so these are the instructions. 

Is there a potential place to look?

I've got /wp-content/plugins/simple-press/ moved and /wp-content/sp-resources/ copied to the new location, but the database tables-- any idea where they might be?

EDIT: I searched in ftp and found the files starting with sf- and they are moved as well. Yet when I refresh the new location of the forum it doesn't take. Must I delete the old one before the new one will render?

Yellow Swordfish said
No - these are NOT files. They are tables in your MySQL Database that you would have set up when you first installed WP.

To view these, export, import etc., you need to use a tool such as phpMyAdmin (which will be available via cPanel which I believe you said you use).

Ahh, great. Thank you.

It makes it sound so simple so it must be me but I moved the tables to the new location and refreshed the forum on the outside and it didn't take. 

Anything I am missing perhaps?

Do I have to delete the old forum for the new one to show up?

Ike said
It depends, what didn't take?

Are you seeing anything? Are you seeing the old forum still?

If you are displaying it on a different WP page then I don't think you would need to delete the old forum to get the moved one to show, can you give an example of what URL the old and new forums are displaying on?

Yes, for example: my public portal is mysite.com

and the private site is mysite.com/members (wishlist membership site) and they are two different installations of wordpress. 

I transferred all of the tables from the 2nd installation of mysite.com/members/forum to the new one mysite.com/forum

Nothing on the new one changes when I transfer all of the tables and follow the instructions; changing the permalinks, admin panel, etc. 

I hope you see any holes in the procedure I am presenting.

Yellow Swordfish said
'Transferred all of the tables'.  How do you do that?

In php my admin I exported the tables with the prefix "sf" from the members site with all of my content and imported them on the public portal. + users and usermeta

Yellow Swordfish said
So did you overwrite the users and usermeta tables that were already there?
And have you checked the content of the new tables are intact and correct?
Do both of these two databases use the same WordPress table prefix? If not did you change the imported ones?
And what do you see in the forum admin?

EDIT: transferred the post data, yes, everything in the tables are correct. Still not working on the outside yet. used wp_sfdata

Regarding the table prefix: I deleted all traces of simple press tables and checked in php my admin and it was confirmed.

Then I reinstalled simple press and I do have two prefixes. One is kak_sfexample and the other is wp_sfexample

So I wonder what gives there? And which I should use?