Stats pages down

[farmerisme]

I would not even attempt at a diagnosis, but it is goofed.

[stutters]

sweet. that doesn't look like fun.

[stutters]

and it's not. the server had a major heart attack last night due to a power surge or power failure. sql doesn't like being shutdown without notice. atm, it seems like the entire database has been lost. i'm going to get coffee, but you may want to start finding things to throw at me. i hadn't yet crossed off the "schedule routine database backups" off the todo list.

Welcome to the MySQL monitor.  Commands end with; or \g.
Your MySQL connection id is 7197 to server version: 4.1.18-nt

Type 'help;' or '\h' for help. Type '\c' to clear the buffer.

mysql> SELECT DATABASE();
+------------+
| DATABASE() |
+------------+
| NULL	   |
+------------+
1 row in set (0.02 sec)

mysql> \u hlstats;
ERROR 1049 (42000): Unknown database 'hlstats;'
mysql>

[DNA]

YES..I may be in the top ten again for awhile...

[stutters]

stats are back. i'm not sure how, but somehow i managed to salvage and repair the tables instead of dumping the entire database. one of the tables went from 50ish mb to about 35mb, so there's some loss.

 

 

for being incredibly hung over, i'm pleased.

[mookie]

The only thing the stats are good for is looking up Steam IDs from handles anyway; any amount of loss of actual stats is acceptable.

[alvin]

I'm going to get the record for most suicides!

[stutters]

i *think* there's a backup scheduled daily. after hearing about loki's suicides, no way i'm going to lose those stats.

 

(bzip + mysqldump + batch) - hangover = done for the day.