REGISTER or LOGIN to have the annoying ads removed.
Thread Rating:
  • 0 Vote(s) - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
phpMyAdmin Queries for use with MyBB

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
DELETE FROM `mybb_privatemessages` WHERE `deletetime` = 'X'

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

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

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

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

Creation or Addition

Modifications or Edits

Please feel free to submit your own!

Possibly Related Threads...
Thread Author Replies Views Last Post
  MyBB Central Plugins Work with MyBB 1.4? S.T.A.R.S 2 2,419 Oct 20, 2011, 07:45 PM
Last Post: F4T4L 3RR0R
  Importing a database with PHPMyAdmin Gonzo 2 2,385 Aug 13, 2010, 08:20 AM
Last Post: Gonzo
  How many queries are too many? Riverthief 22 9,294 Feb 06, 2010, 01:36 PM
Last Post: danysalva92

Forum Jump:

Users browsing this thread: 1 Guest(s)