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
How to move forum to a new site with an existing WP installation
Avatar
Christine Baker
NW Arizona - high desert
Member

Silver Members
sp_UserOfflineSmall Offline
Jan 30, 2015 - 12:56 am

I'm combining two sites and I want to move the forum.  I've looked at https://simple-press.com/docum.....or-domain/

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).

I have NO idea what to do.

I have imported blogs into multisite installs and imported data into all kinds of forum software, but I've never simply ensured that all database tables were moved.  Don't have the slightest clue how to do that.

Thought I'd install Simple Press on the site I want to move it to and then simply import the data with some plugin.  I noticed that I can import OTHER forums' data, but what about Simple Press?

Feel like I'm sitting on my brain ...

Avatar
Yellow Swordfish
Glinton, England
SP Master
sp_UserOfflineSmall Offline
Jan 30, 2015 - 2:27 am

I guess I have always tended to be a little hesitant about trying to automate such a process because, let's face it, it can go wrong and often people will use such a tool without realising the implications or what it is actually going to do and then blame us for the result!

It is actually surprisingly easy. The main problem would come about if the WordPress table prefix was different on the source and target databases. If they are the same then simply using an export and import in a tool such as phpMyAdmin will do the trick.

So the first option is that I could talk you through how to do that and it really is quite straightforward.

The second option would be that I could write you a script that you could run in your database - again fairly simple but will take longer as I probably wouldn't be able to do that until early next week.

And both of those options assume that your source and target websites have access to the phpMyAdmin tool. It would be most unusual for them not to have as it is commonly bundled with your hosting control panel.

andy-signature.png
YELLOW
SWORDFISH
Avatar
Christine Baker
NW Arizona - high desert
Member

Silver Members
sp_UserOfflineSmall Offline
Jan 30, 2015 - 3:10 pm

I just looked at both databases in phpMyAdmin and the prefix is wp_ , so that should be ok.   They're both multisite installs, but the forum is part of the main blog.

I'm always up for learning something new, never messed with tables before.   So do I just export all the tables with wp_sf and then import at the new site (after backing up)?  And then follow the instructions at "If you need to move your Simple:Press installation to a new domain"?

Thanks!

Avatar
Ike
Sawtry, UK
Member
Free Members
sp_UserOfflineSmall Offline
Jan 30, 2015 - 3:29 pm

Yes - if you are moving just the database from one install of SP to another (as you said you have installed SP again) and your database prefix is the same, you should be good to go with the export / import.

Avatar
Christine Baker
NW Arizona - high desert
Member

Silver Members
sp_UserOfflineSmall Offline
Jan 30, 2015 - 6:53 pm

SP isn't installed yet on the destination site, but that's what I had planned on doing.

I suppose I also have to install all the plugins before importing the tables?

Avatar
Mr Papa
Simi Valley, CA
SP Master
Free Members
sp_UserOfflineSmall Offline
Jan 30, 2015 - 9:23 pm

are you importing plugin data? if so, yes... otherwise it will try to install the add on plugins from fresh...  of course, if you imported a backup after that, it would probably work fine too...  but have data set up first is usually best...

Avatar
Christine Baker
NW Arizona - high desert
Member

Silver Members
sp_UserOfflineSmall Offline
Feb 26, 2015 - 11:56 pm

Ok, I finally worked myself up to installing everything on the new site, I exported all the wp_sf tables at the old site and then tried to import the file.   Got this error:

Error
SQL query:

MySQL said:

#1062 - Duplicate entry '1' for key 'PRIMARY'

What do I do now?

Avatar
Yellow Swordfish
Glinton, England
SP Master
sp_UserOfflineSmall Offline
Feb 27, 2015 - 1:50 am

It sounds like the target table already has data in it. The target tables need to either be empty - or -more commonly - the import SQL script needs to drop the target table and then recreate it before inserting the data.

The easiest way is when you export your data from the source database to make sure you include the DROP table option and also ensure you export both data and structure.

andy-signature.png
YELLOW
SWORDFISH
Avatar
Christine Baker
NW Arizona - high desert
Member

Silver Members
sp_UserOfflineSmall Offline
Mar 10, 2015 - 2:25 am

Ok, I tried this again:

#1044 - Access denied for user 'desert'@'localhost' to database 'lakemead_wp'

What do I need to do now?

Appreciate your help!

Avatar
Yellow Swordfish
Glinton, England
SP Master
sp_UserOfflineSmall Offline
Mar 10, 2015 - 4:04 am

We can not possibly help you diagnose why your user is denied access to your database I am afraid. That is going to be down to you and your mySQL server and it refers to your database access user not the wordpress user.

I am not sure what your last post said originally but it seems it had an image and different text so if there is anything else related to WP or SP that might help I don't mind looking at the evidence but this message is way beyond our help.

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: 643
FidoSysop: 577
Conrad_Farlow: 531
fiddlerman: 358
Stefano Prete: 325
Member Stats:
Guest Posters: 616
Members: 17343
Moderators: 0
Admins: 4
Forum Stats:
Groups: 7
Forums: 17
Topics: 10117
Posts: 79590