Page 1 of 2

Posted: Sat Sep 06, 2003 4:14 pm
by DADINK13
Big-O Mark wrote:You're all going down :D.
Speaking of going down...when's the forums gonna get fixed??

Posted: Sun Sep 07, 2003 8:48 am
by Big-O Mark
DADINK13 wrote:
Big-O Mark wrote:You're all going down :D.
Speaking of going down...when's the forums gonna get fixed??
MySQL ate some tables. In the past, our ISP has been able to rebuild them for us without the loss of any data. At this point, it's all up to them ... if they can't do it, the alternative is to restore from a semi-old backup, which will not be fun.

Posted: Sun Sep 07, 2003 1:20 pm
by Anthony
That's insane... I have never heard of any other phpBB forum doing that :-/... Which leads me to believe your host is... less then what they would like to say they are...

Posted: Sun Sep 07, 2003 2:29 pm
by fuuucckkers
PhaseDMA wrote:That's insane... I have never heard of any other phpBB forum doing that :-/... Which leads me to believe your host is... less then what they would like to say they are...
It has nothing to do with phpBB. It's the MySQL Database Backend.. which I suspected from the beginning.. as posted in another thread someplace around here.

As a question to Mark though.. how exactly does MySQL eat the tables? If you can explain in a bit more detail.. how do the tables just get screwed up all of a sudden.. and not work? Enlighten me (us) ! :)

Posted: Sun Sep 07, 2003 2:34 pm
by harra
I don't know if this is what is in play with Big-O's mySQL tables or not, but we had a similar thing happen at the forum I help administer for MS Access related stuff. The owner of the forum (and DBA) said that mySQL can get real nasty if one of the tables gets corrupted. When it gets corrupted you (the user) gets presented with those familiar mySQL errors on the screen. But if a user/users keep hammering the website with refresh calls or whatnot, the table can get so corrupted, it just can't be recovered. In our instance, we had a user that made 300 refresh calls in 1 hour after the table got corrupted and hosed a table, fortunately, our DBA makes frequent backups so we didn't lose much (about a day)

Posted: Sun Sep 07, 2003 4:20 pm
by Walker
How Old is this backup? I mean, most of the frequent posters joined around the same time. I think we should all remeber our post count so the DB can be restored.

Posted: Sun Sep 07, 2003 6:55 pm
by Matt
W4LK3R wrote:How Old is this backup? I mean, most of the frequent posters joined around the same time. I think we should all remeber our post count so the DB can be restored.
As brian once put it "You are not your fucking post count."

Posted: Sun Sep 07, 2003 7:29 pm
by Walker
LOL. Just Making a suggestion.

Posted: Mon Sep 08, 2003 6:29 pm
by Timelessblur
Well I willing to be the back up would make me go down rank again

Posted: Mon Sep 08, 2003 6:42 pm
by Walker
Im Not! LOL :|

Posted: Mon Sep 08, 2003 7:02 pm
by insomica
Post counts? Who cares about post counts.

Posted: Mon Sep 08, 2003 9:08 pm
by Walker
I mean... they dont matter.. but i feel its likethe more posts, the better quality of the poster.

Posted: Wed Sep 10, 2003 2:31 pm
by insomica
More posts does not mean a better poster. Quantity does not mean Quality.

Posted: Wed Sep 10, 2003 2:44 pm
by Walker
I KNOW we have gone over this... but is missing from this topic.

Posted: Wed Sep 10, 2003 2:54 pm
by Anthony
insomica wrote:More posts does not mean a better poster. Quantity does not mean Quality.
So much for what my College English teacher just told me today... Does that mean I don't have to come up with 40+ "brain storming" ideas.