Support Forum

Start All Over Again

EV Erik de Vries
Erik de Vries
Member

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.

11 Answers

New Answer

MP Mr Papa
Mr Papa
Member

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

EV Erik de Vries
Erik de Vries
Member

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

 

EV Erik de Vries
Erik de Vries
Member

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

YS Yellow Swordfish
Yellow Swordfish
Member

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?

EV Erik de Vries
Erik de Vries
Member

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.

 

MP Mr Papa
Mr Papa
Member

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

EV Erik de Vries
Erik de Vries
Member

What is the best sequence,

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

 

Thx

EV Erik de Vries
Erik de Vries
Member

Everything is back on the new domain.

That means everything is up and running with no problems, no data has lost.

Thank you for the support.

 

E

MP Mr Papa
Mr Papa
Member

Outstanding news! good to hear! thanks for the update – glad we could help!