EQEmulator Forums - Power going out keeps corrupting my database

EQEmulator Forums (https://www.eqemulator.org/forums/index.php)

- Support::Windows Servers (https://www.eqemulator.org/forums/forumdisplay.php?f=587)

- - Power going out keeps corrupting my database (https://www.eqemulator.org/forums/showthread.php?t=39590)

Power going out keeps corrupting my database

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.:-x

Quote:

Originally Posted by TylerBarnes (Post 239490)

Open up CMD

Code:

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. :grin:

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)