MyBB Community Forums

Full Version: How to Delete all my Private Messages at Once! I have 27K msgs!
You're currently viewing a stripped down version of our content. View the full version with proper formatting.
Hey guys!
I have 27,000 private messages and I have not deleted any single message since 2012 on my forums... Do you know how to delete all of them at once? Is there a way to do it?

Thanks!
Try running in MySQL:

DELETE FROM mybb_privatemessages WHERE uid='1' 

This is assuming your uid is 1, if not just change the 1 to the correct number.
Goto your database, and delete all the entries in the privatemessages table or something like that.

Alternatively, developing a plugin that does that for you on install might also be option.
#1146 - Table 'myforums.mybb_privatemessages' doesn't exist
Check your table prefix, it could be different.
Who's suggestion did you try? Mine or the above one?
I got it thanks. I tried Ircher's suggestion. You go in privatemessages table and you delete it from there. Thanks!