ERROR (HY000): Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock'
This is a commonly seen error in database driven sites. The same error can show up when a connection or restart for MySQL server is attempted via commandline.
A quick check of the log files may reveal that the actual error faced by MySQL server is “InnoDB: Unable to lock ./ibdata1, error: 11”.
In our role as Outsourced Tech Support for web hosting providers, database errors are one major category of issues we resolve for the customers.
InnoDB is a storage engine for MySQL. Due to its speedy crash recovery, InnoDB is the preferred engine for high available databases.
But there are times when InnoDB throws error, such as ‘Unknown table engine ‘innodb”. Today, we’ll see when and why this error happens and how to fix it.
For a website owner or a web host, a hard disk crash is one of the most upsetting things that can happen to their business. It means service downtime, loss of business and valuable time spent on data restoration.
To minimize such catastrophe, many server owners keep regular backups, and even use RAID servers. But even with these precautions, sometimes things can go for a toss when the backups also get lost in a hard disk crash.