Jump to content
Sign in to follow this  
JRWR

Mistakes were Made

Recommended Posts

Last night Andy and Another PHP Dev were trying to get Invision Powerboard to authenticate to the MediaWiki User Database, They called me when the PHP Dev where having issues with the way that PCGamingWiki is setup

We discovered that the bridge they were trying to use, was the wrong type, it was to use PowerBoard’s user database for auth and not mediawiki, So we uninstalled and left it like that.

 

We got a report the next morning that all auth groups had been wiped from the database, I still do not really know how this happened, but I suspect the Auth Bridge was to blame, All page permissions where gone as well, and I saw no way of fixing it, but a database rollback

 

That’s where things went south, I got a backup off our Backup Server from the 25th, and exported the current wiki as XML, but I found out that the database backup copy was bad, really bad, like eat your goat and piss on your oatmeal bad, it crashed mysql HARD, After some “science†(Hex Editor, and some luck) and was able to get Mysql to mount the InnoDB store

It segfaulted (crashed) midway into the raw SQL dump, Fuck

After some more “Science†and some really good luck, I got a Full Database dump. And deleted all the old data, or so I thougth…. That was a incomplete dump, I forgot to push the binlogs to current….

So after some more “science†and some 4 hours later, we now have a working database that is 2 days old and with the current content of PCGamingWiki, Sorry TruePCGamer, Hope you had some old backups for the last two days

Share this post


Link to post
Share on other sites

Please sign in to comment

You will be able to leave a comment after signing in



Sign In Now
Sign in to follow this  

  • Found PCGamingWiki useful? Please consider making a Donation or visiting our Patreon.
  • Who's Online   2 Members, 0 Anonymous, 278 Guests (See full list)

  • Recently Browsing   0 members

    No registered users viewing this page.

  • Forum Statistics

    1,409
    Total Topics
    7,621
    Total Posts
×
×
  • Create New...