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