MyBB Central

Full Version: phpMyAdmin Queries for use with MyBB
You're currently viewing a stripped down version of our content. View the full version with proper formatting.
Hey,

Here we can build a list of queries you can run in phpMyAdmin to help your board. To find a query you can use the search feature (CTRL + F).

Make sure to backup your database before running any queries!

Deletion or Removal
Prune or Delete PMs
Code:
DELETE FROM `mybb_privatemessages` WHERE `deletetime` = 'X'

Prune or Delete Threads
Code:
DELETE FROM `mybb_threads` WHERE `fid` = 'X'

Prune or Delete Posts
Code:
DELETE FROM `mybb_posts` WHERE `fid` = 'X'

Prune or Delete Thread Ratings
Code:
DELETE FROM `mybb_threadratings` WHERE `tid` = 'X'

Remove Warnings
Code:
DELETE FROM `mybb_warnings` WHERE `uid` = 'X'

Creation or Addition

Modifications or Edits


Please feel free to submit your own!