Database Problem - Resolved - Some Messages Lost

Nifty-Chicken

Administrator
BYC Staff
14 Years
Dec 26, 2006
41,754
35,165
1,572
California - SF East Bay
My Coop
My Coop
Hey Everybody,

Really sorry that we were down for a while. The PM Messages table became corrupt in the database and we've been working hard for the past while to try to fix the table.

Unfortunately the PM Messages table was corrupted so bad that we couldn't repair it, so we were forced to revert to our most recent backup which was from very early this morning.

We are VERY VERY sorry that any messages sent and received since the time of the backup were lost.
sad.png


The good news is that our backup system works GREAT and saves us from any really major catastrophes.

Thanks for your patience as we worked through the problems.
 

Nifty-Chicken

Administrator
BYC Staff
14 Years
Dec 26, 2006
41,754
35,165
1,572
California - SF East Bay
My Coop
My Coop
I'm just glad I was able to get it fixed without having to pull in people with a higher pay scale.
wink.png
big_smile.png


It was really tricky because I had to choose between getting the forum back online ASAP or keep trying to fix the broken Messages table. After a while of failed attempts with the messages table I decided to just bite the bullet and restore from this morning. A total bummer to loose the PMs from the first part of the day, but I think the lessor of two evils (the other being the forum being down for much longer).

Again, it sure is great to know that our backup system works so well! The database for BYC is super monstrously huge (imagine indexing 5 million posts, all the messages, and a ton of other data). It is a bear to work with, and we've got a lot invested into keeping it up and running, but it sure helps me to sleep well at night knowing that the "worst case scenario" is almost always less than 1 day's worth of data being lost.

For our techy visitors, here is how I do backups for BYC's database: http://www.nifty-stuff.com/daily-mysql-database-backup.php
 

New posts New threads Active threads

Top Bottom