Results 1 to 2 of 2
Like Tree1Likes
  • 1 Post By Will.Spencer

Thread: vBulletin Power Tips Using MySQL

  1. #1
    Will.Spencer's Avatar
    Will.Spencer is offline Retired
    Join Date
    Dec 2008
    Posts
    5,033
    Blog Entries
    1
    Thanks
    1,010
    Thanked 2,329 Times in 1,259 Posts

    vBulletin Power Tips Using MySQL

    Here are some power tips for doing things to your vBulletin database directly from the MySQL command line.

    Always backup your database before editing it manually, or you'll be sorry...

    Delete Guest Posts

    delete from post where userid = 0;

    Delete Soft Deleted Posts

    delete from post where visible = 2;

    Delete Soft Deleted Threads

    delete from thread where visible = 2;

    Delete Thread Redirects

    delete from thread where open="10";
    Brandon Sheley likes this.
    Submit Your Webmaster Related Sites to the NB Directory
    I swear, by my life and my love of it, that I will never live for the sake of another man, nor ask another man to live for mine.

  2. #2
    Will.Spencer's Avatar
    Will.Spencer is offline Retired
    Join Date
    Dec 2008
    Posts
    5,033
    Blog Entries
    1
    Thanks
    1,010
    Thanked 2,329 Times in 1,259 Posts
    And when too password attempts lock you out of vBulletin...

    Clear vBulletin Admin Lockout

    DELETE FROM strikes;
    Submit Your Webmaster Related Sites to the NB Directory
    I swear, by my life and my love of it, that I will never live for the sake of another man, nor ask another man to live for mine.

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •