How To Repair Database In Phpmyadmin

Summary: Several factors like faulty hardware, bugs in MySQL software, server crash, etc., tin turn a MySQL database decadent. A corrupt database becomes inaccessible, and you might get errors when trying to open the database. This web log will outline the errors you lot may come across due to MySQL database corruption. Too, information technology will discuss the steps to repair the MySQL database using phpMyAdmin easily.

How to Repair MySQL Database using phpMyAdmin?

When trying to open a corrupt MySQL database, you may receive any of these errors:

Table './mysql/user' is marked as crashed and should be repaired
Unexpected end of file
Got error ### from table handler

Irrespective of the mistake message you lot encounter, you must repair the database to restore all its components.

Steps to Repair MySQL Database using phpMyAdmin

Note: We will be accessing phpMyAdmin using XAMPP application for Windows or open the url 'http://localhost/phpmyadmin/' to showtime using it. Or, you may admission phpMyAdmin using cPanel.

One time phpMyAdmin opens, click the Databases tab from the primary carte du jour. This will open a list of MySQL databases.

Click the corrupt database.

A list of all the tables in MySQL database will open. Click Check All to select and repair all the tables. Once the tables are selected, aggrandize the 'With selected:' drop-down, then select the Repair Tabular array option.

Annotation:To repair a specific table, check merely that table. In our example, nosotros've selected ii tables 'Customer' that we want to repair and recover.

The phpMyAdmin will run the query for the MySQL tables. On successful completion of the repair process, a message indicating that the database tables are repaired volition appear.

Note:You lot cannot repair InnoDB tabular array(s) using the 'REPAIR TABLE' option. On trying to repair an InnoDB tabular array, you will become an error "the storage engine doesn't support repair." To fix a corrupted InnoDB table, refer to this blog.

Still Can't Admission the MySQL Database?

While the in a higher place method might work, it has certain shortcomings. It only allows repairing a single database at a time which can be time-consuming. Also, fixing corruption in a large database may require additional fourth dimension, thereby exceeding database reanimation. Further, the method may fail to repair a severely corrupt MySQL database. And, forcing InnoDB recovery with a value greater than 'iv' involves data loss risk.

Consider using a specialized MySQL database repair tool like Stellar Repair for MySQL to reduce database downtime and get back all the information. The tool can repair severely corrupt MySQL databases. Likewise, it supports repairing both MyISAM besides as InnoDB tables. In addition, the software also helps recover all the data while preserving the original table structure and formatting.

Steps to repair MySQL databases using the software are as follows:

Download the demo version of Stellar Repair for MySQL software.

Launch the software after completing the downloading and installation procedure. This will open up the software home page with the following Didactics dialog box. Click OK.

Select the version of your decadent MySQL database, then click Scan to select the information folder containing the databases yous want to repair. Click OK.

The software displays a list of all the MySQL databases. By default, all the databases are selected. You may also choose specific database(due south) to be repaired, then click Repair.

Click OK when the 'Repair Consummate' message box opens.

A preview of all the recoverable tables, views, triggers, etc. gets displayed on the left pane of the software window. Click on an item to view its contents in the right pane.

Click Save on File carte du jour to save the repaired information.
Select the file format to save the repaired data, enter details to connect to your MySQL server, then click Relieve.

A 'Saving process completed' bulletin is displayed on completion of the saving process. Click OK.

Open your MySQL binder and view the repaired file.

Conclusion

This blog discussed the procedure of repairing a MySQL database using phpMyAdmin. But using this method has some downsides. It only supports repairing MyISAM tables. Y'all need to separately force_innodb_recovery to recover information from corrupt InnoDB tables. Further, you tin can repair databases one past one. You tin overcome these limitations by using Stellar Repair for MySQL software. Information technology helps repair both MyISAM and InnoDB tables. Also, it saves time by allowing you to set multiple databases simultaneously.

About The Author

Charanjeet

Charanjeet is a Technical Content Writer at Stellar®who specializes in writing most databases, e-mail recovery, and email migration solutions. She loves researching and developing content that helps database administrators, organizations and novices to fix multiple problems related to MS SQL and MySQL databases and Microsoft Exchange.

Best Selling Products