Wednesday, February 10, 2010

Resolving “No MySQL pid file found” Error Message

MySQL database corruption mostly results into displaying of an error message at the time of mounting the database. For detailed reason of the MySQL database corruption, you can view the MySQL error log. In most cases of log description, a solution is also mentioned along with the cause of the error. If the solution works, then you can continue working on your database. However, if the solution is not provided or fails to resolve the error message, then an ideal way is to restore the data from an updated backup. But if in case, the backup file is not available or backup falls short to restore the required data, then you will need to use advanced MySQL Repair application to repair the corrupted database.

Consider a practical case, where the underneath error message pops up when you attempt to mount your MySQL database:

“No MySQL pid file found”

On viewing the MySQL error log, below information is displayed:

“InnoDB: Page may be an update undo log page. Page may be an index page where index id is 0 40
InnoDB: (index `PRIMARY` of table `piprd/Broadcast`) database page corruption on disk or a failed
InnoDB: file read of page 2280. You may have to recover from a backup.
InnoDB: It is also possible that your operating system has corrupted its own file cache and
InnoDB: rebooting your computer removes the error.
InnoDB: If the corrupt page is an index page you can also try to fix the corruption
InnoDB: by dumping, dropping, and reimporting the corrupt table. You can use CHECK
InnoDB: TABLE to scan your table for corruption”

The error log clearly states that the database is corrupted. Few reasons for corruption could be operating system corruption (also mentioned in error message), MySQLD improper shutdown, and virus attack.

Resolution:

To resolve the above error message and to access the database components, you will need to look for efficient Repair MySQL Database software. A MySQL Repair tool should only be purchased only after the testing its demo version.

Stellar Phoenix Database Recovery For MySQL is a powerful repair tool whose demo version allows you to preview all the repairable InnoDB and MyISAM database components. Compatible with MySQL 5.x and 4.x, the MySQL Repair utility supports Windows 7, Vista, XP, 2003 and 2000 operating systems. The tool is completely non-destructive.

Resource Taken From :- http://www.articlesengine.com/Article/Resolving--No-MySQL-pid-file-found--Error-Message/502384/1

No comments:

Post a Comment