SQL error?

[phranklee]

I'm getting this error on the front page of my website (getofftheinternet.net):

Warning: Error establishing mySQL database connection. Correct user/password? Correct hostname? Database server running? in /hsphere/local/home/phrankle/getofftheinternet.net/libs/db.php on line 87 Warning: mySQL database connection is not active in /hsphere/local/home/phrankle/getofftheinternet.net/libs/db.php on line 125

What's up?

[mothchick]

I'm having similar issues with my database as well although I opened a support ticket.

[phranklee]

Yeah, I just did too.

[cnanninga]

Same issue - seems to be caused by too many DB connections. Still waiting for a reply to my ticket.

[mothchick]

I got a reply and it sounds like it may be awhile...great

There have been some table corruption issues on the MySQL server causing various issues with certain tables/databases. We are aware of the issue and currently in the process of repairing the issue. Due to the number of databases it may take some time to repair all the databases, but we are certainly working to resolve the issue as soon as possible.

[phranklee]

Looks like it's back up.

[derwert]

If you're using MYiSAM for the engine for your tables then you'll want to create a cronjob to check the tables each night and repair if needed. myisam is fast but prone to corruption. If you don't need as much speed then change the engine for your table to InnoDB.