Monday, December 7, 2009

“Error Signal 11” at MySQL Server Startup

Error message at the startup of MySQLD (MySQL Server) primarily occurs when the database is corrupted or damaged. Few main factors responsible for MySQL database corruption are improper MySQLD shutdown, concurrent modification of same database component, and software bugs. Two major outcomes that you might encounter after database corruption are unmountability of database and inaccessibility of records. To surmount both these hazards and easily access the database records, a standard way is to restore it from an updated database backup. However, in case of database backup unavailable, the only alternative left is to repair your database using powerful MySQL Repair application.

Consider a scenario, where you encounter the below error message when you attempt to start MySQLD:

“MySQL got signal 11”

After the above error signal appears, MySQLD shuts down automatically and then restarts on its own, resulting in improper shutdown of your MySQLD.

Note: If the above scenario occurs several times in a single day, the probability of severe database corruption increase manifold.

Cause:

The root cause for the occurrence of the above error message is hitting of MySQLD with a bug.

Resolution:

If your database gets corrupted due to improper shutdown of MySQLD, then you can repair your database using below steps:

You will need to check the level of corruption by running the underneath command:
mysqlcheck [options] dbname tablename [tablename2... ].
After determining the level of corruption, you will need to use the below command to repair your database:
repair table tablename [,tablename1...][options]

The above steps prove successful in repairing the corrupted database in most of the corruption scenarios. However, if the above error message persists even after following the above steps, then it means that database is badly corrupted and requires a powerful third-party MySQL Recovery software.

Such MySQL Repair tools provide comprehensive database repair by throughly scanning the database using high-end scanning methods. With highly interactive user-interface and to-the-point documentation, these software are self-explanatory without any technical knowledge. Moreover, these utilities are non-destructive in nature and perform recovery without making any modifications in original file.

No comments:

Post a Comment