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

Ok it seems my stxt database has some kind of corruption that the host says can't be fixed. Even the old backups will not restart for some reason, apparently corrupt too.

What can be done aside from deleting entire thing and starting again?
what can be done to prevent it just all happening all over again?
Is mysql prone to this kind of thing happening?

what other gallery rotator scripts (that dont use mysql) are available?

you probably need a new host, not a new script...:2 cents:
who do you host with now?

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

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.

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. :2 cents:

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.

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

Resolved, thanks for the kind words! :thumbsup

who's the host?

Backups.

Glad to hear it's working again :) and no prob! always glad to help

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 :)