Database Problem - Resolved - Some Messages Lost

Date sort Score sort
Nifty-Chicken

Nifty-Chicken

Administrator
BYC Staff
18 Years
Dec 26, 2006
45,611
54,230
1,832
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.
 
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
 

Similar threads

W
    • Sad
    • Love
Lost one of our girls to a red tail hawk
Replies
9
Views
551
AGeese
AGeese
figit
Is this 12-on/12-off a fairly dummy-proof schedule for CX?
Replies
2
Views
910
figit
figit
S
    • Love
    • Like
Seeking some advice
Replies
3
Views
343
muddy75
muddy75
D
Tree safety issue?
Replies
3
Views
689
SandyRiverChick
SandyRiverChick
Zinnia Hens
    • Sad
Lost 2/4 chickens within a month and now shelless eggs? Please help me solve the mystery!
Replies
2
Views
290
Zinnia Hens
Zinnia Hens

New posts New threads Active threads

Back
Top Bottom