How to clean up DB after flood of spam?

Welcome Guest! To enable all features please Login or Register

thx1200
63.2% (Friendly)
YAF Camper Topic Starter

7 years ago

I had a flood of spam and I killed the users and the topics got marked as deleted -- that was easy.

But the DB has grown a bit and I want to just nuke the spam posts permanently. How do I do that? I couldn't find a way within the settings. I looked at the DB and can see the flags indicating the topics and messages were deleted, but I want them permanently purged from the DB to reclaim space.

Thanks.

Wanna join the discussion?! Login to your YAF.NET Support Forum forum account or Register a new forum account

Sponsor

tha_watcha
100% (Exalted)
YAF.NET Project Lead 🤴 YAF Version: 4.0.1 BETA

7 years ago

The easiest way would be via sql

delete FROM [{databaseOwner}].[{objectQualifier}Message] WHERE IsDeleted = 1

thx1200
63.2% (Friendly)
YAF Camper Topic Starter

7 years ago

Thanks! I had no idea it would be that easy. 🙂

Juan hernandez
51.2% (Neutral)
YAF Forumling

7 years ago

Awesome, thanks. ive had that issue in the past.

Important Information: