In theory yes. You need – as a minimum – all of the SP tables (those starting ‘sf’) and the WP users and usermeta tables.

You will need to update urls after the move. The urls held in the WP settings > general admin panel for starters.

If you do not move the WP posts tables then you will need to create a new page for the forum to use and set it on the integration > page and permalink panel.

You will need to update the WP Permalinks- also under the settings admin menu. And you will need to then update the forum permalinks on the forum admin > integration > page and permalink panel.

You will also need to check all of the storage locations (also under Integration) and update all of them to their new locations.

Then also check all forum admin panels to ensure all options are still set correctly. You will need to change any URLs in the admin panels you may have set – like the login and registration redirects for example.

It sounds like a lot but actually this should be pretty quick.

What you will lose, however, are any URLs or Links within posts that point to the old site domain location.

There is an excellent WordPress plugin to change your urls after moving to a new domain.

I usually go into phpMyadmin and edit the blog url in the options table. Then add this plugin: https://wordpress.org/plugins/velvet-blues-update-urls/ and select all the boxes except the last, then run it.

I suggest once you do that go into sp-tools and run repair on all the databases. 

Regards..

Sounds pretty cool…

Yellow Swordfish said
Sounds pretty cool…

Yes it is.. Saved my ass a time or two. 

Just did this one that used to be eBayMotorsSucks.com. Everything changed over well including the previous simplepress posts.

Neat. Impressive actually.

Thanks for the advice, everyone… but unless someone else in the community that this page is actually FOR steps up and takes some responsibility, then it’s up to me to do all the tech stuff as well as everything else, and so it is what it is. (Clearly, I don’t mean the community here… of helpful SP people… it’s a different one.:P) Given that, I think that the lesser of the evils actually would be to re-create the forums on the new site. There aren’t enough users yet to make it worthwhile to move people over, either (that’s been deliberate… it was a test site.)

if you JUST want the groups and forums, you can copy the wp_sfforums and wp_sfgroups tables to the new site and they will be good to go…  without users, you just cant get the sftopics and sfposts tables..

That sounds like a great idea; the only thing is… Little do you know how non-extremely-techy I am!

(warning: dumb questions ahead…)

Where can the wp_sfforums and wp_sfgroups tables be found? On WP somewhere? On the host (Dreamhost)?

How are they copied?

Where are they copied to on the new site (or are they connected to the host)?

(remember… everyone was warned!

in your db… on your server… using a db tool such as phpmyadmin.. certainly your host gives you one to use…

export from db on server 1 and then import into db on server 2…

your wp db prefix might be other than wp_

(nods)

It’s making sense. Making sense is good. Thanks to everyone for the patience shown. I will definitely try this. If it gets to be too confusing, well, I know that re-creating the forums will work, so that’s always a fallback.

you are welcome!