|
|
|
#1
|
||||
|
||||
Our ShopForum Database got corrupted. The good news is that we were able to restore it from tape backup. The bad news is that we lost about one day of posts.
__________________
Bill Wood - Retired Webmaster My Personal Website 1998 Mercedes E430 2010 Toyota Sequoia My Photo Albums |
#3
|
||||
|
||||
Bill,
Did you randomly back up the files the other day? Or does it do it on an automatic basis? Or do you do it periodically? Good think it was backed up!
__________________
2006 E350 w/ 155k miles (Daily Driver) Previous: 1993 300E 3.2L Sedan w/ close to about 300k miles 2003 E500 Brilliant Silver (Had 217k miles when totalled!) 1989 300E with 289,000 miles (had for <1 yr while in HI) 03 CLK 500 cabrio (Mom's) 2006 C230k (Dad's) 1999 S420 (Mom's/Dad's) 2000 C230k Sport sedans 2001 CLK320 Cabrio (Mom's) 1995 C280 My First Mercedes-Benz... (155k miles. EXCEPTIONAL AUTOMOBILE. Was Very hard to let go of!) |
#4
|
||||
|
||||
It is automatically backed up 3 times a week.
__________________
Bill Wood - Retired Webmaster My Personal Website 1998 Mercedes E430 2010 Toyota Sequoia My Photo Albums |
#5
|
||||
|
||||
Thanks for having a good backup. You guys, and this site rule. Glad it's back.
I do have a question though. Is the "archive" of the 1999 Tech help stuff still around, or did it get combined with the Tech help forum when you updated the site's software a while back. No biggie, I was just wondering. Thanks.
__________________
Bob Roe Lehigh Valley PA USA 1973 Olds 88, 1972 MB 280SE, 1978 Datsun 280Z, 1971 Ford T-Bird, 1972 Olds 88, 1983 Nissan Sentra, 1985 Sentra, 1973 230.6, 1990 Acura Integra, 1991 Volvo 940GLE wagon, 1983 300SD, 1984 300SD, 1995 Subaru Legacy L wagon, 2002 Mountaineer, 1991 300TE wagon, 2008 Murano, 2007 R320CDI 4Matic 52K, some Hyundai, 2008 BMW 535xi wagon, all gone... currently 2007 Honda Odyssey Touring, 2014 E350 4matic |
#6
|
|||
|
|||
I think that 3 backups a week is not a great plan, unless the database has a "transaction log". With your current plan, you run the risk of losing data, as we know. It seems to me that a database product called mysql is in use. This product might not have the transaction log so in the event of a crash, you lose anything newer than your last backup. There is no way to restore data from the log. To better protect the database, there should be more backups per week, say 7 or even 14. There is no real need to save them all; simply saving the latest 3 backups would be fine.
My databases, (I am a database administrator), get completely backed up daily and we ensure that our transaction log is fully protected. The log is also stored on completely different disks which isolates it from general database failures. Crashes like the one you have can happen at any time, so we like to minimize the downtime and eliminate data loss if possible.
__________________
VR 1967 250SL |
Bookmarks |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
OBD II Error Code P0446 - 1999 C230K | seanieboy81 | Tech Help | 7 | 11-16-2004 10:10 AM |
PO107 error code | ericp | Tech Help | 1 | 07-18-2004 06:08 PM |
108 speedometer error | Litton | Vintage Mercedes Forum | 5 | 01-07-2004 04:18 PM |
Help tips on error code P0171 & P0170? ('97 C280) | RProsser | Tech Help | 1 | 08-09-2003 12:16 PM |
Resetting the Error Message | DiDi | Tech Help | 5 | 11-01-2002 06:32 PM |