Tips to Recover Data from Corrupt MySQL Database

Stellar Repair for MySQL can help in recovery of data from corrupt or damaged MySQL database. In this article I will show how to repair corrupt or damaged MySQL database’ file when it becomes corrupt.

Corruption in MySQL database can happen due to any uncertain reasons. Hardware problem, virus attach, power failure, bugs in MySQL itself, automatic system shutdown are the most common causes for MySQL database corruption. A bad hard drive can write garbage value in the MySQL database and then MySQL reports error messages.

“Cannot load from mysql.proc. The table is probably corrupted”
“MySQL error code 145= Table was marked as crashed and should be repaired”

There are several ways available to recover data from corrupt or damaged MySQL database:

InnoDB Force Recovery

It helps in recovery of data from corrupt MySQL database. By default, 0 is the value of innodb force recovery and database administrator can change it from 1 to 6. A higher value of InnoDB force recovery includes all the functionalities of lower values. For Example, 6 includes all the functionalities of values 5, 4, 3, 2, & 1.

Note: Only use InnoDB force recovery value greater than 0 when there is an emergency situation and make a backup copy of your database before trying it. Backup will help you in recreating the database when needed.

Steps to use InnoDB force recovery:

• First of all stop MySQL server (mysqld) and copy all the files from /var/lib/mysql.
• Use innodb-force-recovery to mysqld.

[mysqld]
Innodb_force_recovery=5

• Start the MySQL server.
• Dump all the databases.
• Now restore the database from dump.

Restore from Backup

If the above method does not help then try tested & updated backup. It is the ideal solution to recover database from corrupt database file. Go with the next method, if backup is not available or too old.

Stellar Repair for MySQL

The only remaining method is use Stellar Repair for MySQL software if above solutions fail to restore the database from corrupt MySQL InnoDB database.

Stellar Repair for MySQL is developed by Stellar data recovery and the current version is 6.0. It is available for Windows as well as for Linux but you need to copy your MySQL database from Linux machine to Windows machine and run repair operation over there then after restore the database from Windows machine to Linux machine.

»»  Read More...

How to repair corrupted WordPress MySQL Database

Suddenly My database stops responding & displays following error message:

./loginname_blog/wp_options' is marked as crashed and should be repaired

The error message was shown when I was trying to login my Wordpress Blog & access to the server. After checking this error, I thought that I have lost my database permanently as the message indicates itself that WordPress table wp_options has been crashed or become corrupted & it needs to repair. In last, I decided to search about this error on internet. After full research on error, I found two options to repair corrupt MySQL database table: 

[1] Using cPanel: Use following steps: 

a. Log in to your cPanel 
b. Go to MySQL Databases. 
c. Modify Databases, select a database from the drop-down box  
d. then click the Repair DB button.

[2] Using phpMyAdmin: Use following steps: 

• Open your phpMyAdmin and select the database from which you want to repair table. 
• Select the tables that you want to repair. 
• From Drop down menu, choose Repair table option. This will execute the REPAIR TABLE SQL query on the selected tables and they will be repaired.

In case, above steps get failed to repair the damage MySQL database then you should create a new database and re-installing WP. After completing WP installation, try to extract all your blog posts from the corrupted post database file with a text editor and then recreate all your blog postings one by one. 

It is very lengthy & long procedure. If you want to get rid of this long procedure then you should use MySQL Database Recovery Software. The software repairs corrupt MySQL database as well as all corrupted MySQL database objects. These Recovery Software are very easy to use & repair corrupt database in few easy steps. 

»»  Read More...