Go Back  Xtreme Visual Basic Talk > Announcements > Announcements > Power outage and db crash

Thread Tools Display Modes
Old 03-09-2002, 05:41 PM
Bob Schwarz, Sr.'s Avatar
Bob Schwarz, Sr. Bob Schwarz, Sr. is offline
Just One of the Boys
Join Date: May 1998
Location: Aurora, IL, U.S.
Posts: 1,274
Default Power outage and db crash

We are having severe weather here and the high winds knocked power out. Before the backup generator could kick in the server went offline for a brief period of time. When it was rebooted, because of the abrupt shutdown of the mysql server, the user table of the db was corrupted. The first 4 backups I tried were also corrupt. I finally got one from over 3 hours ago to work. Anyone that posted or signed up 3 hours prior the outage will have to re-post or signup again. If your username works everything is ok. If you get an error saying there is no such member then you were lost while repairing the db. I was worried for a short time that I might have lost the db altogether. Everything seems back to normal now.
There is a good lesson I learned today. You can never have too many backups. I was lucky enough to just have changed the backup cron task to fire every 20 minutes instead of every hour and to save 24 hours worth of backups. Previously, I only saved 6 hours worth. This could have been a major disaster if none of the backups worked.
.Net Forum
Reply With Quote

Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is On

Forum Jump


Free Publications
The ASP.NET 2.0 Anthology
101 Essential Tips, Tricks & Hacks - Free 156 Page Preview. Learn the most practical features and best approaches for ASP.NET.
Programmers Heaven C# School Book -Free 338 Page eBook
The Programmers Heaven C# School book covers the .NET framework and the C# language.
Build Your Own ASP.NET 3.5 Web Site Using C# & VB, 3rd Edition - Free 219 Page Preview!
This comprehensive step-by-step guide will help get your database-driven ASP.NET web site up and running in no time..