Check And Repair SQL Database: The Guide You Want Is Here

November 7th, 2015 | by Ravi Chahar || 6 Comments |

For a website creating a database is the most significant part to complete. When it comes to any error in the database then you have to know how to check and repair the database? In this tutorial, I am going to tell you about checking and repairing of the database tables.

There are many things to do with the database using PhpMyAdmin. You can add new users to your database, change WordPress username and password and a lot more. In this tutorial, you are also going to use it.

How To Check And Repair The Database?

First you should know how to check a database? Though for checking and repairing of a database, there are similar steps to follow. There is only one difference between both. You will see it later.

Before starting the process, you should always keep a backup of the database of your website. It is always recommended to keep a backup of your website and the database.

There are some steps to follow. I am going to list them one-by-one and you have to go through those steps.

Step 1: You have to login to your Web Hosting account and then go to cPanel provided to you. Search for the databases section.

Step 2: Click on “phpMyAdmin” and a new tab will open for you.

Step 3: You will have to select the name of the database you want to check. You can see the name of the database in the left-hand-side menu. There will be a plus sign by clicking at which you can explore all the databases. After that, you can select the database you want to check.

Step 4: After selecting the database, all the tables will be shown to you. If you want to check the database then you have to select all the tables present. Just click at the bottom in the box and all the tables will be selected.

Step 5: Now you to take the final step for checking the database. You will find many options in the bottom of all the tables, there will be a drop-down menu. You have to find “check table”.

Step 6: You will see a message showing that all the tables have checked. If you want to see the status of the each table then in front of each table, you will see “OK” under “Msg_text” column field. It means all the tables are doing great. There is nothing to worry about.

If you don’t get “OK” message then you have to repair the database using a repair option. Most of the time a database gets repaired using this option. But if you don’t get the results you are hoping for, then you have to upload the backup of your old database.

Repair The Database Within One Second

As you did in the previous section of checking. You can go through the same steps.

Step 1: Go to your cPanel>>Databases>>phpMyAdmin.

Step 2: Find the database you want to repair and click to the database.

Step 3: Select all the rows of the database.

Step 4: Find an option “repair table” in the drop-down menu and your database will get repaired within one second.

After checking the database, you can select the table you want to repair. As if you don’t see “OK” in front of any table then select all the tables and repair the database using “repair table”.

Check And Repair The Database: Have You Done It?

You know that a database of your website should keep safe and great in working. There shouldn’t be any error. Always check and repair SQL database using the process explained above.

Have you done it before? Do you want to try it? Go to your phpMyAdmin and you can check and repair the database of your website.