Start anew with all posts?

[Sefiros]

Well, you see, my situation is that I want to take my forums down for the anniversary of my site to upgrade the forums.

I want to delete all files, then install 2.2.9 and then import the needed databases, but only for posts and forums. I just don't know which I have to import. So I thought you guys could maybe help me?

Thank you for your precious time.

:banana:

[Xenon]

you have to make a dump of forum, thread and post table.
then run a query to set all post userid's = 0

but then all posts would have guest status.
the other possibility is to save also the user fields...

[Sefiros]

So a new install and then only import 'forum','thread','post' and 'user'?

That's all? Nothing running around in some other tables? ;)

[Xenon]

if you import the users, you also have to import userfield and usergroup table :)

[TECK]

As well the attachment, avatar, customavatar, forumpermission, moderator, poll, pollvote, profilefield, threadrate (if enabled) and usertitle (if you use custom titles).

The best way is to simply import the hole tables and drop them on a test board first, just to make sure you don't kill your database.

[Xenon]

hmm that's not exactly right Floren. you know you could just reset all the attachments/titles and avatars/vote things...

so really neede are just the one i posted :)