Power going out keeps corrupting my database

[TylerBarnes]

I live in the older part of a college town and the power regularly goes out. I use WAMP which has Apache, PHP and MySQL neatly packed into a single program. However, whenever the power gets cut to my server it causes all the data in my database to I guess get out of sync and then become corrupt. Several weeks of work, player's characters, adjusted spawn rates are lost.
There has to be a better way of doing this. Any tips?
I thought Heidi SQL was backing up the data but I opened the .sql document and all it said was, "Not selected" when I could've sworn I had everything selected so that's going to be a fun fix.

[Akkadius]

Originally Posted by TylerBarnes

I live in the older part of a college town and the power regularly goes out. I use WAMP which has Apache, PHP and MySQL neatly packed into a single program. However, whenever the power gets cut to my server it causes all the data in my database to I guess get out of sync and then become corrupt. Several weeks of work, player's characters, adjusted spawn rates are lost.
There has to be a better way of doing this. Any tips?
I thought Heidi SQL was backing up the data but I opened the .sql document and all it said was, "Not selected" when I could've sworn I had everything selected so that's going to be a fun fix.

Open up CMD

mysqlcheck --auto-repair -u <username> -p <databasename>

It will go through and run through repairing your database tables automatically.

That'll be $1,000

Just kidding.

[ghanja]

I'm guessing recommending an UPS would be too obvious.

http://www.amazon.com/CyberPower-CP4...cyberpower+ups

Likely wouldn't keep your computer up for long, but with the power panel software and USB connection from the computer to the UPS, it could at least offer a means of a clean shutdown at around 25% battery life.

I've got four of these for the home rack and I haven't looked back. It's saved me a lot of heartache and ass pain.

http://www.amazon.com/CyberPower-CP1...cyberpower+ups

(recommended for those with PFC power supplies in their desktops/home servers)