Screwed By Bad Backups and Autoupdate Reboots
After almost a week's worth of MySQL problems and why I was rushing a fresh backup, the web host dropped the ball and more than a month of data has been lost on BowlingCommunity.com, WyldRyde's Forums, my friend Angel's site, Magnet Angel, and two new unlaunched sites I've been working on.
The host, AIT.com says:
Over the last 24 hours we experienced an unforeseeable configuration issue with your MySQL server which resulted in the loss of some of your data. In order to correct the issue, we found it necessary to apply the most recent backup of the MySQL database. Based upon initial review of the archived files, the backup was no more than 48 hours old. However, we found upon applying the backup that not all of the data files were being consistently updated with each backup. As a result, it is possible that data in your database is not up-to-date as of the time of the initial problem that began last evening. Unfortunately, your data was affected by this issue. In response to this incident, our backup procedures for the your MySQL server, along with all AIT customers are being modified to ensure this does not happen going forward. However, at present there is no more current data that we can provide to you in your database at the present time.
To accommodate you for this issue, we will continue to work on ways to restore data that is more up-to-date, however at the present time you have a working, functional MySQL database. We sincerely apologize for any inconvenience, and we appreciate your patience in this matter.
Oh and this was after they said, yesterday:
Thank you for your patience. I apologize for the inconvenience, there was an issue with our centralized MySQL server earlier. We had to readd your user with the correct privileges. I want to assure you no data was lost. If there is anything else we can do for you please let us know.
Meanwhile MySQL doesn't stay up long enough for us to do anything to it. We hope to have the forums up again, in some state, tonight but I'm still not sure how much has been lost and if it's worth restoring from my own backups two months ago.
AIT's support staff has been courteous but their response to these problems have been painfully slow. We felt in the dark through most of this and still feel like our problems are unimportant to them. I've requested credits for these problems when someone from Customer Service called earlier this evening but the call dropped and no one called back. An email to AIT's CEO advising him of our experience has also gone unanswered.
Posted in BowlingFans.com
, IRC & WyldRyde IRC Network
by usrbingeek at 2007-10-12 00:02 ET (GMT-5) | 0 Comments | Permalink