914World.com > Server crash ...

SirAndy

Oct 15 2007, 07:26 PM

arrggghhhh ....

mySQL crashed and corrupted the database table that holds all the posts ever made on the board!

my last backup was from 9/14 (

) which would have been a bitch if we had lost all those posts inbetween then and now.

fortunately, i was able to use the mySQL repair function with success. looks like we didn't lose any posts ...

Andy

Grimstead

Oct 15 2007, 08:54 PM

You Rock!

SirAndy

Oct 15 2007, 08:55 PM

werking ???

iamchappy

Oct 15 2007, 08:57 PM

Weeeeee

Dr Evil

Oct 15 2007, 09:07 PM

Thanks man, you rock!

thomasotten

Oct 15 2007, 09:29 PM

Sweet, are we on a Linux platform?

OmegaM1A1

Oct 15 2007, 09:36 PM

Aha, and here I was thinking my school's network really didn't like 914's.

Good job.

VaccaRabite

Oct 15 2007, 10:04 PM

Any ability to do an automated nightly backup to something or other? Tape, an external HD, something like that? Even with ~7k users and 5 years of data, I can't imagine the database is all that big.

If it is a ton of data, you could go incremental with a full backup on sunday nights or somwthing like that. Lots of OTS software to automate a backup.

These days its usually faster for me to reformat, ghost an OS, and restore data from the backup then it is to actually try and fix whatever the problem was.

Zach

SirAndy

Oct 15 2007, 10:10 PM

database is ~ 1 GB (

)

uploaded pictures etc. is ~ 12.4 GB in 145227 files (

)

Andy

Lou W

Oct 15 2007, 10:45 PM

You da man. Thanks Andy

jimtab

Oct 15 2007, 10:49 PM

Ahandy...I think it is time to terminate the SQL...(whatever that is) with extreme prejudice. Is there an upgrade we could all treat the site to with donations? Split it between a bunch of us and it might be easily done....or do I Know even less about computer pricing than fixing 914s? Yeah, I know....

PeeGreen 914

Oct 15 2007, 11:14 PM

Hey, If we can contribute to the board I am sure there are some of that would like to. Maybe you could let us know where we could send some funds to make the board a better place, and make people know that this is completely optional. I have always wanted to contribute anyway. We all appriciate the work and the space you provide Andy.

SirAndy

Oct 15 2007, 11:22 PM

seriously, this is pissing me off ... why do you guys always have to bring up $$$ ???

if i needed your fu$$$ng cash, don't you think i'd ask?

why can't you leave it alone? seriously. please. can we move on to something that does not involve your hard earned money?

Andy

PeeGreen 914

Oct 15 2007, 11:39 PM

Because we want to help. It would be different if you were soliciting it from us. However, I, and I am sure many others, want to feel like we are doing our part. It has nothing to do with the fact you may not need it, want it, or not. We just want to pull our weight. Sorry to bring it up.

SirAndy

Oct 15 2007, 11:45 PM

i know. i know. shitty day at work. phone ringing off the hook. nothing works as it should be. then the 914world server takes a dump ...

sorry guys, i probably shouldn't post right now ... i need a beer ...

Andy

KELTY360

Oct 15 2007, 11:47 PM

QUOTE(SirAndy @ Oct 15 2007, 10:22 PM)

seriously, this is pissing me off ... why do you guys always have to bring up $$$ ???

if i needed your fu$$$ng cash, don't you think i'd ask?

why can't you leave it alone? seriously. please. can we move on to something that does not involve your hard earned money?

Andy

OK, can you imagine how pissed all the post whores would have been if we'd lost a months worth of posts........oh, the humanity.