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
Start All Over Again
Avatar
Erik de Vries
Member
Free Members
sp_UserOfflineSmall Offline
Aug 16, 2013 - 10:54 am

Due to Wishlist not connecting with AWeber - Payment Procesor I had to install everything again.

I did backup the complete wordpress folder, but I had to remove that database, so all users etc are gone.

So the question is,  If i can get my old Database, In witch table can I find my Groups - Forums and Topics.

That is most important for me.

Or are they located somewhere in the backup folder I also got?

Thanks.

Avatar
Mr Papa
Simi Valley, CA
SP Master
Free Members
sp_UserOfflineSmall Offline
Aug 16, 2013 - 11:16 am

we cannot answer the question about the backup folder since we have no idea what was captured there...  not sure what you mean by backing up WordPress folder... our data is in the db, not folders (some uploaded files, avatars, etc would be)

our db tables are in the same db as wp, just mostly in their own tables, though we have some information in wp tables...

having users is going to be critical though... every topic/post made in your forum is tied to a specific wp user (or guest).. so if y our users are gone, who the posts belong to will be all messed up...

so in your database, our tables are the ones that begin with sf... something like wp_sffforums or wp_sfgroups...  your db prefix may be other than wp_ too...

and then additional user information is stored in the wp usermeta table on a per user basis.. 

so you can get the information, but without users from the wp db, the posts wont tie to anyone and likely look like from guests..

Avatar
Erik de Vries
Member
Free Members
sp_UserOfflineSmall Offline
Aug 16, 2013 - 1:50 pm

Thank you,

Then I will first import all the user back from the old DB, after that I will try to import the SP releated tables back into it.

Wish me luck ;-)

 

Avatar
Yellow Swordfish
Glinton, England
SP Master
sp_UserOfflineSmall Offline
Aug 16, 2013 - 2:43 pm

Indeed - I hope it all works out.

andy-signature.png
YELLOW
SWORDFISH
Avatar
Erik de Vries
Member
Free Members
sp_UserOfflineSmall Offline
Aug 17, 2013 - 5:02 am

Ok,

I got the old forum back including all Groups, Forums and Topic and users.

Now I have installed SP on a new domain, what is the best way to export all the content from the old forum to the fresh installed forum?

 

Thx

Avatar
Yellow Swordfish
Glinton, England
SP Master
sp_UserOfflineSmall Offline
Aug 17, 2013 - 5:18 am

Depends on where you are starting from. Have you made a SQL dump file of the old data? And does this file contain DROP TABLE commands?

andy-signature.png
YELLOW
SWORDFISH
Avatar
Erik de Vries
Member
Free Members
sp_UserOfflineSmall Offline
Aug 17, 2013 - 6:10 am

Yes I have an SQL dump, and yes it does contain the DROP TABLE commands

Update: I can see with Notepad++ everything is there.

Can you tell me wich tables I have to import?

Like..

wp-sfforums

wp_sfgroups

Everything?

Thank you.

 

Avatar
Mr Papa
Simi Valley, CA
SP Master
Free Members
sp_UserOfflineSmall Offline
Aug 17, 2013 - 12:45 pm

yes.. you will need all the sf* tables... and then the wp users and wp usermeta tables...

Avatar
Erik de Vries
Member
Free Members
sp_UserOfflineSmall Offline
Aug 18, 2013 - 3:15 pm

What is the best sequence,

Installing a fresh copy of wordpress and then install SF, and after that import the DB tables?

 

Thx

Avatar
Yellow Swordfish
Glinton, England
SP Master
sp_UserOfflineSmall Offline
Aug 18, 2013 - 4:24 pm

It is what I would do personally.

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: 650
FidoSysop: 577
Conrad_Farlow: 531
fiddlerman: 358
Stefano Prete: 325
Member Stats:
Guest Posters: 619
Members: 17361
Moderators: 0
Admins: 4
Forum Stats:
Groups: 7
Forums: 17
Topics: 10127
Posts: 79625