How to delete all reply for all thread

[borbole]

Originally Posted by Max360

hi,
I trying to clean up my vbulletin database to free up some space so i want to delete all post reply and only maintain the first post for each threads, so any idea how to delete them via phpmyadmin? . I'm Running vb4.2.0 . tq

First of all make a backup of your database then run this query:

DELETE FROM post WHERE parentid !=0;

If you use a custom prefix append it to the table name in the query above. Then as last step you might want to rebuild the threads, posts and the stats at the Maintenance->General Update Tools section in your Acp. Hope it helps.