Subscribe to the::unwired's RSS Feedthe::unwired at Twitterthe::unwired on Facebookthe::unwired on Google Plus
the::unwired Article
FORUM: Had to restore the Forum with a 5 days old backup
Posted by Arne Hess - on Wednesday, 05.11.03 - 11:32:43 CET under 06 - Site News - Viewed 6589x
Not Tagged

For any reason, last night one table of the Forum database crashed (the topics table) and I had to restore the Forum with a previous backup. Unfortunately that backup is 5 days old so we lost the past 5 days... :cry:

While I first thought I just could restore the crashed topics table I realized after that i doesn't work because the matching between topics and postings wasn't accurate anymore. :roll:
I've backup'ed your postings and try to restore it but I'm not sure if it will work. The user accounts I've already restored, so all user accounts from the past 5 days back again.

Sorry for the inconvenience! :|

Cheers ~ Arne


Related Articles FORUM Had to restore the Forum with a 5 days old backup

  • No related articles found.
Posted by APA on 05.11.03 - 15:38:44

Backup more frequent smile

Posted by Arne Hess on 05.11.03 - 15:52:22

Nope, normally there isn't a problem... :?

And thank you for your kind words to backup more... ;-) tongue

I think backups are the most forgotten feature in the computer industry... :-(

Posted by bubadr on 06.11.03 - 21:58:08

With a little work you can restore the index table & then inject entries that point to the recent articles. It's probably abit more work now that you have old articles, new articles, and newer articles like this one. But it is still doable assuming that you have access to the database & some basic DBA skills

Posted by APA on 06.11.03 - 22:16:24

Let me tell you one of the best secrets in the industry, it's not the backups that are the most forgotten feature. You would be shocked to see how many companies do make backups, but never try a RESTORE smile (that's the most forgotten feature). I personally know of one company that went bancrupcy due to such a "small technical mistake" the case was covered up by the motherhouse of this insurance, but still they are now off the market at all smile

Social Sharing
This Week's Top Stories
Feeds & More
Awards & More
Recent Discussions
© Copyright 1998 - 2013 by the::unwired® & Arne Hess
All rights reserved!
the::unwired is a registered trademark of Arne Hess.
All trademarks are owned by their respective companies.
All site video, graphic and text content is copyrighted to the respective party and may not be reproduced without express written consent.