Speaking of going down...when's the forums gonna get fixed??Big-O Mark wrote:You're all going down .
More On Post Counts
Moderators: Big-O Ryan, Big-O Mark, Matt, Anthony
- Big-O Mark
- Shortbus Driver
- Posts: 804
- Joined: Sun Jan 20, 2002 5:20 pm
- Location: Big-O Software
- Contact:
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.DADINK13 wrote:Speaking of going down...when's the forums gonna get fixed??Big-O Mark wrote:You're all going down .
-Mark
Big-O Software
Big-O Software
-
- Moderator
- Posts: 815
- Joined: Sun Sep 22, 2002 3:33 pm
- Contact:
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.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...
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) !
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)
Ray
"Everybody needs friends. No one wishes to be without them. But never lose sight of the fact that it is your friends who will lead you along the paths that you will follow."
—Gordon B. Hinckley
"Everybody needs friends. No one wishes to be without them. But never lose sight of the fact that it is your friends who will lead you along the paths that you will follow."
—Gordon B. Hinckley
As brian once put it "You are not your fucking post count."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.
-Matt
Timelessblur wrote:I only know 4 langueges. Engish, Band Engish, Really bad Engish and Timelessblurain
- Timelessblur
- Extreme Groupie
- Posts: 800
- Joined: Sun Dec 15, 2002 9:06 pm
- Contact:
Well I willing to be the back up would make me go down rank again
http://www.myimgs.com/data/timelessblur ... omulan.jpg
Yeah I know I got pulled in but its a nice way to kill time
my link for kings of Choas
Yeah I know I got pulled in but its a nice way to kill time
my link for kings of Choas
Who is online
Users browsing this forum: Google [Bot] and 1 guest