Select Page

innodb crash


How to resolve MySQL ‘1146 table doesn’t exist’ errors in your server

How to resolve MySQL ‘1146 table doesn’t exist’ errors in your server

In our role as Hosting Support Engineers for web hosts, we manage servers with various services such as web, database, mail, control panels, FTP, etc.

MySQL is the most commonly used database server in Linux hosting and handling the databases and resolving the errors associated with it, is a common task that we perform. (more…)

How to fix ‘Unknown table engine ‘innodb” error

How to fix ‘Unknown table engine ‘innodb” error

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.

(more…)

Database crash rescue – How we re-built an InnoDB MySQL database when ibdata1 file was corrupted

Database crash rescue – How we re-built an InnoDB MySQL database when ibdata1 file was corrupted

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.

(more…)

How to safely recover/repair InnoDB tables in MySQL

How to safely recover/repair InnoDB tables in MySQL

Server crashes could leave databases in inconsistent states. While there are many tools available to repair MYISAM tables in MySQL, InnoDB repair is not always so straightforward. MySQL could refuse to start up, leaving you with in-determinate downtime. If your MySQL error logs show an InnoDB corruption, it’s time to tread carefully. (more…)