clear all posts/threads

[BigJohnny]

is there a way to easily delete all posts/threads/replies on the board, and reset all the users post count to 0?

Im just setting up a board, thats being tested, and i wanted to delete all of the posts up to this point so i can start another test on a bare board.

[Adrian Schneider]

I think this would work...[sql]TRUNCATE TABLE (prefix_)post;[/sql]
[sql]TRUNCATE TABLE (prefix_)thread;[/sql](obviously replacing (prefix_) with your table prefix if you have one!)
Then go to your maintenance area of the AdminCP and update all the counters (post counts, thread/forum caches, etc).

[BigJohnny]

ok ill try that when im ready.... i dont want to run any matainence options that will ++++ anything up.... and i think there are a couple of options that could seriouslly mess things up if run un-nessecarily?!

[Adrian Schneider]

All of the maintenance tools (under Update Counters) are harmless. They just "rebuild" caches of the data. An example would be recounting your posts. Usually you it just increments when you create a post and decrement when you delete one. But if you were to delete 500 posts via MySQL (or if you have pruning enabled!) it would be out of sync, which can be both good and bad.