mysql ...corrupt DB what are the options and what prevention for the future.

**woj** · 11-18-2008, 11:05 AM

you probably need a new host, not a new script...

who do you host with now?

**AnniKN** · 11-18-2008, 11:09 AM

I can try and fix your database, if you have a dump hit me up. (No charge)

**Fortress-Jay** · 11-18-2008, 11:51 AM

What you need is real time hot backups of your mysql database so if it gets corrupted you can roll back to minutes or hours before the corruption.

**rowan** · 11-18-2008, 11:55 AM

The only time I've had corruption issues with mysql is when there's been a violent shutdown, in other words something like an operating system panic or a lockup, which means any pending data hasn't been fully written out to the file system. On reboot the OS fixes up the file system as best as it can but that often does result in a loss of some data, and not always just the stuff that was sitting in RAM waiting to be flushed to disk.

I agree with woj, sounds like your host wasn't really on top of things (assuming they manage your server), unless the corruption has been around for long enough that all of the non corrupt backups have rotated out.

**longdongsilver** · 11-18-2008, 12:12 PM

thanks for helpful replies, you guys are correct i got it going again.

The guys at stxt really do know their stuff and once i forwarded their step by step guide to the host regarding how to fix a mysql database with innodb errors. It all started working again fine. The host it seems was just trying to restart mysql from an old backed up version but they were not deleting the innodb files first ....or something like that.

However it does seem mysql with any script is open to fucking up now and then so a more regular db backup have been scheduled.

**longdongsilver** · 11-18-2008, 12:13 PM

Originally posted by AnniKN

I can try and fix your database, if you have a dump hit me up. (No charge)

also a very big thanks to you for this offer, that was very kind of you. thanks

**Godsmack** · 11-18-2008, 01:20 PM

Resolved, thanks for the kind words!

**u-Bob** · 11-18-2008, 02:38 PM

who's the host?

**dready** · 11-18-2008, 03:03 PM

Backups.

**AnniKN** · 11-18-2008, 03:14 PM

Glad to hear it's working again

and no prob! always glad to help

**Owen Pierce** · 11-19-2008, 12:06 AM

Heh yeah, anything can corrupt. backups are crucial.
one backup option would be to setup a master/slave setup on mysql. then you get instant backups to any slave(s) you have setup. And of course if those are on different machines, you can take advantage of that whole situation for speed.
but yeah, multiple computer backups are the bare minimum.

Or have mysql do an UpdateLog and setup a cron to process those queries into a backup database (prolly should be myisam if it's on the same computer, so that its not in the innodb file). and clear the log. Cuz that baby will get HUGE

mysql ...corrupt DB what are the options and what prevention for the future.

mysql ...corrupt DB what are the options and what prevention for the future.

Comment

Comment

Comment

Comment

Comment

Comment

Comment

Comment

Comment

Comment

Comment