Unknown storage engine 'InnoDB'

[noobdvlpr]

Hi. yesterday i was trying to login to this website I’m trying to create and i got this error:

Connection failed: SQLSTATE[HY000] [2002] Can’t connect to local MySQL server through socket ‘/var/lib/mysql/mysql.sock’ (2)

but after just refreshing the site a few times it worked okay and I could use the site. Then just now i tried to login again and i got:

Fatal error: Uncaught exception ‘PDOException’ with message ‘SQLSTATE[42000]: Syntax error or access violation: 1286 Unknown storage engine ‘InnoDB’’

and in the phpmyadmin all my tables in the collation tab it says “in use” and in the type tab it is blank. I tried:

REPAIR TABLE 'table_name'

as suggested in this stackoverflow discussion but that did not work either. please help me. TIA!

[noobdvlpr]

ah well, apparently the hosting providers are in a bit of a jam. They were trying to do an update and it backfired on them. -.-’ haih.

[molona]

Glad you found the problem