Repair corrupted/crashed mysql tables via phpmyadmin

Mysql database tables may get corrupt and crash, due to several reasons.This article is on how to repair corrupted/crashed Mysql tables via phpMyAdmin.

MySQL is known for its stability, but as any other software application, there may be bugs that could crash the Mysql tables. For eg., unstable operating system on which Mysql is installed or hardware problems or it could even be a simple power failure. Any of these could lead to Mysql table crashes.However there is no reason to panic. It is easy to repair Mysql tables via phpMyAdmin.

How to repair Mysql tables via phpMyAdmin upon a corruption and crash?

When one or more Mysql tables get corrupt and crashes, they could be restored by carrying out the below mentioned steps via phpMyAdmin.

  • Login to phpMyAdmin
  • Select the affected mysql database. If you own only one database, then it would have been chosen by default
  • In the main panel, mysql tables for the database would be listed. Check the boxes besides the tables that you want to repair.
  • At the bottom of the window (below the list of tables), you will find a drop down menu. Choose “Repair Table” from the menu
repair mysql tables

phpMyAdmin should automatically fix the chosen mysql tables. Once it is fixed, take a backup of the mysql database! Take regular backups of your mysql database used in wordpress or any other application.

Related Videos

How to repair a corrupted MySQL/MariaDB database using HeidiSQL?
Title
How to repair a corrupted MySQL/MariaDB database using HeidiSQL?
How To Recover MySQL Database From Data Files
Title
How To Recover MySQL Database From Data Files
How to Repair MySQL Database Tables: WordPress options is marked as crashed and should be repaired
Title
How to Repair MySQL Database Tables: WordPress options is marked as crashed and should be repaired
How to Recover a Crashed MySQL Database
Title
How to Recover a Crashed MySQL Database
How to manually restore wordpress with ftp & phpmyadmin
Title
How to manually restore wordpress with ftp & phpmyadmin
2 comments on “Repair corrupted/crashed mysql tables via phpmyadmin
  1. My tables crashed once as the Overhead got increased. Do you know what causes “Overhead” to develop in the tables

  2. […] Repair mysql tables via phpmyadmin upon a corruption and crash […]

  3. Thanks a lot for this tip.

    Helped me a lot.

Leave a Reply

Your email address will not be published. Required fields are marked *

*

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <s> <strike> <strong>