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
#1
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!
Reply


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

Forum Jump:


Users browsing this thread: 1 Guest(s)