Become a Vendor


Developer for


How to Check and repair a corrupted MySQL database on CentOS server using SSH

Server problems many times can cause corruption of scripts and modules

So now we can see how check & repair MySQL database table through SSH.

Normally we use PhpMyAdmin to manage our MySQL databases.

1. First of all, you have to log in as root using SSH.

2. Now, you have to run this command to check the desired database.

# mysqlcheck -r [your-database-name]

Here, mysqlcheck command will check the database.
-r will repair the corrupted tables of the database.

3.If the above command does not work in any case then you can use myisamchk command:

# myisamchk -r /var/lib/mysql/[your-database-name]/*


Here, you should keep this thing in mind that MyISAM is the default storage engine for MySQL.
myisamchk command will check the database.
-r will repair the corrupted tables of the database.

Leave a Reply

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

Appteam to offer you a better experience on this site uses its own and third-party technical, analytical and profiling cookies. The site also uses third-party tracking cookies to adapt advertising to your preferences.

If you want to know more or refuse consent to the use of cookies click here. By continuing to browse, you consent to the use of cookies.

Privacy Settings saved!
GDPR Center

When you visit a website, it can store or retrieve information on your browser, mainly in the form of cookies. Check your personal cookie services here.

These cookies are necessary for the website to function and cannot be disabled in our systems.

In order to use this website we use the following technically required cookies
  • wordpress_logged_in_
  • wordpress_sec
  • wordpress_test_cookie

We use WooCommerce as a purchasing system. 2 cookies will be stored for the shopping cart and order processing. These cookies are strictly necessary and cannot be disabled.
  • woocommerce_cart_hash
  • woocommerce_items_in_cart

  • wordpress_test_cookie
  • wordpress_logged_in_
  • wordpress_sec

Decline all Services
Accept all Services

Main Menu