Select Page

mysql crash recovery


7 reasons why you get ‘mysql failed to start’ errors and how we fix them

7 reasons why you get ‘mysql failed to start’ errors and how we fix them

[FAIL] Starting MySQL database server: mysqld . . . . . . . . . . . . . . failed

Many a times, you’d have come across this message in your server while trying to restart the database server.

Our Dedicated Server Admins support the server infrastructure of several web hosting companies, and this is a common issue we’ve seen in many Linux servers.

Here, we’ll see the common causes and solutions for ‘Mysql failed to start’ issues.

Click here to protect your web & database services from downtime.

(more…)

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…)

10 tips to prevent database corruption in your web hosting servers

10 tips to prevent database corruption in your web hosting servers

Many websites run database-driven applications, and a single missing entry in these tables can lead to website downtime. Database corruption is an alarming scenario for webhosts, who end up spending time and effort repairing and restoring their customer databases.

At Bobcares, our staff resolve such scenarios everyday in their role as Outsourced Support Engineers for web hosting providers. And we’ve learned that its better to stay pro-active and prevent a DB corruption, than fire-fighting a website downtime.

(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…)