When you move your WordPress database you will move the forum data with it. And presumably you will also move all of the folders containing plugins, themes and other data from your current wp-content and sub-folders.

You may need to reset the forum permalinks after the move and you WILL need to check through all of the option settings in the various admin panels, The main issue will be that any non-relative URLs embedded in forum posts will still point to your old domain but other than that it should be OK.

I am not going to move the entire website or database to a new location. I am just moving the forum to a different website.

Moving just the forum tables is not really going to work. Simple:Press is an integrated WordPress plugin not a stand alone forum. It makes use of certain WordPress data – most importantly the users and the usermeta table data. It also requires a WordPress page object which would need to be recreated if going to a new WordPress installation. But basically, moving just the forum specific data would lose all of your users data.

So basically the answer is move to bbpress or something like that or keep it at the same website and database.

All the other post, users and custom post types I have in WordPress is possible to export and import with out problem.

To me it’s strange that you can import from another forum with minimal problem, but you cant move with the same forum. I was planning to move the users and everything needed at the same time.

I do hope you make options import Simple Press inn to Simple Press. And sins you already have an importer, don’t I believe it’s extremely hard.

I do like Simple Press and hope I can make something work so I can keep it.

I think you have rather missed the point of what I said.

All I said was that for SP to work on a new domain and instance of WordPress you would need to ALSO move the WP users and usermeta tables. That is actually exactly the same thing if you were using bbPress or any other WordPress forum plugin.

It is the WHOLE point of SP being a WordPress plugin – to integrate with your users that WordPress maintains.

I want to know exactly what I do need to move to get the forum working. I was of course planning to move the users.

And since you don’t have a easy fix, which tables in MySQL do I need to move?

I am sorry but I really do not know what on earth you mean by “don’t have a easy fix”.

Moving SP from one domain to another is the same as moving any WordPress site from one domain to another. Once again – this is a WordPress plugin. It goes WITH WordPress.

If you want to pick and choose the tables you move then the forum tables all start with the prefix ‘sf’ and – as already clearly stated – you also need the Users and UserMeta tables.

You also need – again as stated above – the contents of any folders created that may contain files – these are detailed in the Storage Location panel of the forum admin > Integration section and will most usually be found by default under the wp-content/sp-resources/

I’d like to jump in here if I may as I have a similar question.  I have a large and heavily used forum on one website and a small and mostly ignored forum with only 46 registered users on another.

I want to move the small forum and make it a sub-forum attached to the larger forum  (then close it on the original website).

I’m thinking that if I export and import the Users via WordPress plugins first, can I then just move the small forum files across (probably using Cpanel)? Or is it more complicated than that (assuming there is no import/export facility that I haven’t spotted)? 

there is no export feature in simple press per se…. remember its heavily tied to the wp site and data itself…

the sp data is well contained in the wp_sfxxxx tables (your wp prefix might be other than wp_) however, the user information comes from wp…  so you would have to move all the user db and user meta db info to the new site…  and they would have to have the same user id on the new site as the old site or none of the forum posts will correlate..  if you added the users to the new site, then you would need to update all the user info in the forum info to match…

OK … sounds like the easiest way would be to transfer the users and their details using plugins, then move the posts manually using copy-post-paste and reassign on the fly.  Hey, there’s nothin’ on TV anyway …

If you can massage the source data using SQL queries to update some columns then things might get easier. Let’s see if I can come up with an order. This might not be perfect but it is more or less correct I believe.

1. Source: Change all the user_id of the WP Users and UserMeta tables and the user_id of the SP sfmembers table to enable them to be added to the Target. So basically you would then be circumventing the current auto-increment of the WP users table after you subsequently copy these records in from source.
2. Copy from source the WP Users, UserMeta and SP sfmembers data.
3. You would need to build the SP sfmemberships as well which assigns each new member to a User Group.
4. Create your new forum on the target and note the forum ID.
5. Update the source sftopics and sfposts tables with the new forum ID from target.
6. Change the source sftopics topic_id column to ensure no clashes with taregt topic_id numbers
7. Change the source sfposts post_id column top ensure no clashes with target post_id numbers
8. Now for the tricky bit! Each sfpost record contains the topic_id (now changed in 6 above) and a user_id (now changed in 1 above) which would need to be changed for each topic record to their new values.
9. At this point you should be able to add the data to the target DB.
10. Then go to the forum admin > toolbox > housekeeping and update the forum indexing for the new forum.

And if I missed anything then as long as you make separate backups from each stage it should then be possible to revert to do again.

I am sure Steve (Mr Papa) will shout if he spots I have missed anything.