My database seems to of got corrupt over night. I sent a support ticket to Dreamhost this morning but have not received a reply. I tried logging in via PHPMyAdmin and my user/pass is not recognized even though in the account settings both are still their. I made a new testing account which works but it does not load the table. When i click the table to load the status bar just says loading and nothing else....
So my next option is to check/repair the database via shell but I dont know how to... I tried to google it but they didn't have a dummies guide that I could use...
So if anyone can help would be useful
Its a IPB forum that has been corrupted the IPB site itself does'nt say what the exact error is except that its a DB error.
"Lisa, in this house, we obey the laws of thermodynamics!" - Homer Simpson
"I have my standards. They may be low, but I have them!" - Bette Middler
"It's a book about a Spanish guy named Manual. You should read it." - Dilbert
"Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (11)"
usually implies that the MySQL server is not running or has halted for one reason or another. However given that you can access PhpMyAdmin and it's not causing any problems with a new database I would guess that this problem is no longer existing.
Do you know how it's corrupt? Have you got an error specifying so?
Use myisamchk on MyISAM tables, and use CHECK TABLE and REPAIR TABLE on InnoDB tables.