Support Forum
Support Forum
Silver Members
Offline
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 ...
Offline
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.
 |
YELLOW
SWORDFISH
|
Silver Members
Offline
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!
Offline
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.
Silver Members
Offline
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?
Offline
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...
Visit Cruise Talk Central and Mr Papa's World
Silver Members
Offline
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?
Offline
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.
|
YELLOW
SWORDFISH
|
Silver Members
Offline
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!
Offline
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.
|
YELLOW
SWORDFISH
|
All RSS1 Guest(s)