How To Repair Corrupted Mysql Database Table

In this tutorial, we will show you how to repair a corrupted MySQL database table. Sometimes it happens that your database gets corrupted due to many reasons like it does not get restored properly or the server gets rebooted while updating the database etc you have tried to repair it using phpMyAdmin and it does show that it has been repaired but it is not. However, with the right steps and tools, repairing corrupted Mysql database tables can be done quickly and efficiently. By following the steps outlined in this article, you can repair and optimize your Mysql database tables and get your website or application back up and running in no time.

This article assumes you have at least basic knowledge of Linux, know how to use the shell, and most importantly, you host your site on your own VPS. The installation is quite simple and assumes you are running in the root account, if not you may need to add ‘sudo‘ to the commands to get root privileges. I will show you the step-by-step repair of a corrupted MySQL DB on a Linux server.

Prerequisites

• A server running one of the following operating systems: Linux Server.
• It’s recommended that you use a fresh OS install to prevent any potential issues.
• SSH access to the server (or just open Terminal if you’re on a desktop).
• An active internet connection. You’ll need an internet connection to download the necessary packages and dependencies for MySQL.
• A non-root sudo user or access to the root user. We recommend acting as a non-root sudo user, however, as you can harm your system if you’re not careful when acting as the root.

Repair Corrupted Mysql Database Table

Step 1. First, make sure that all your system packages are up-to-date by running the following apt commands in the terminal.

sudo apt update
sudo apt upgrade

Step 2. Installing MySQL Database.

By default, MySQL is available on Ubuntu 22.04 base repository. Now run the following command below to install the latest version of MySQL 8 to your Ubuntu system:

sudo apt install mysql-server

After successful installation, enable MySQL (to start automatically upon system boot), start, and verify the status using the commands below:

sudo systemctl enable mysql
sudo systemctl start mysql
sudo systemctl status mysql

You can verify the version of MySQL installed by executing:

mysql -V

For additional resources on installing MySQL, read the post below:

• How to install MySQL on Ubuntu Linux √
• How to install MySQL on Rocky Linux √

Step 3. Back up the Corrupted Mysql Database.

The first step in repairing a corrupted Mysql database is to take a backup of the corrupted database. This is important as it allows you to revert to the previous state in case the repair process goes wrong. You can take a backup of the Mysql database by using the following command:

mysqldump -u [username] -p [database_name] > [backup_file_name].sql

Replace [username] with the Mysql username, [database_name] with the name of the corrupted database, and [backup_file_name] with the name, you want to give to the backup file.

Step 4. Check for Mysql Database Table Corruption.

Once you have taken a backup of the Mysql database, you can now check for table corruption. You can use the following command to check for table corruption:

mysqlcheck -u [username] -p [database_name]

This command will check for corruption in all tables in the database. If the output shows any corrupted tables, the table name will be displayed along with the message ‘error’.

Step 5. Repair the Corrupted Mysql Database Table.

Once you have identified the corrupted Mysql database table, you can now repair it. You can use the following command to repair the corrupted Mysql database table:

mysqlcheck -u [username] -p --repair [database_name] [table_name]

Replace [username] with the Mysql username, [database_name] with the name of the corrupted database, and [table_name] with the name of the corrupted table.

Step 6. Optimize the Mysql Database Table.

After you have repaired the corrupted Mysql database table, you should optimize it to ensure that it is functioning properly. You can use the following command to optimize the Mysql database table:

mysqlcheck -u [username] -p --optimize [database_name] [table_name]

Replace [username] with the Mysql username, [database_name] with the name of the database, and [table_name] with the name of the table.

Congratulations! You have successfully repaired the corrupted MySQL database. Thanks for using this tutorial to repair the corrupted MySQL Database in the Linux system. For additional help or useful information, we recommend you check the official MySQL website.