| Re: MYSQL MESS AFTER HOSTING SERVICE CRASH [message #21076 is a reply to message #21068] |
Thu, 11 November 2004 18:39   |
 |
creamywf
Messages: 54
Registered: April 2002
Karma:
|
Member |
|
|
I have another question, which I think is important.
Server crashes and inappropriate shutdowns happen. If the mysql database gets corrupted and has unrepairable files and this happens numerous times over a year, you end up with these unrepairable files hanging on even when you don't know they are there and after a while, collectively they can cause problems.
We had a hosting service whose servers crashed frequently and we repaired the database each time. The last time, over a year ago, it took a lot of work to salvage the databases. Now we've experienced our first improper shutdown and the unrepairable files from a year ago, plus now, are creating havoc.
Members of our forum would prefer to NOT lose any current data (posts, images) as our last back up was prior to the election and there was a lot of discussion during that time. Even going back to the last backup which is now about 3 weeks ago, won't help because that backup contained existing problems from what we went through with crashes with our other host over a year ago.
Other than daily backups, is there anything that can be done about this situation where mysql database files become so corrupted that files are unrepairable when a server shuts down suddenly?
|
|
|
|
Calendar
Search
Help
Members
Register
Login
Home
]