How to delete all posts and forums?

[romaine]

Originally Posted by Dave

I don't see why you would want to start from 1 again but the only way to achieve this is to execute

TRUNCATE TABLE tablename;

queries against all tables that have relationships with the post, thread and forum tables.
This will clear the data and reset the seed.

It is just an example for what I want like a fresh forum because id of posts and forums on my forum are pretty big, like 85323 or 93232...etc If members continue posting then it will generate big numbers like that.

Originally Posted by aycan555

If you dont want any conflicts, just install fresh one, and export only members from old database and import it to new one ..

That's why I asked this question, I am using vB 4.25 and PHP 7 thus I could not use Impex to import members on a fresh forum.