How to Repair a MySQL Database Through Linux and Windows Command Line?

This article describes how to repair MySQL database tables through Linux and Windows command lines.

Repair MySQL Database through Linux Terminal(SSH)

1. Log in to your Linux VPS using Secure Shell (SSH) and connect to MySQL from the command line.

mysql -uUsername -p // Replace Username with your username.

2. Enter MySQL user password and hit Enter. You will see a MySQL prompt appearing. Now, in order to display all databases, type the following command at the MySQL prompt.

show databases;

3. mysqlcheck enables you to check databases without stopping the entire MySQL service. -r argument is used to repair the corrupted tables. mysqlcheck utility efficiently works on both MyISAM and InnoDB database engines. Enter the following command to repair the MySQL database.

mysqlcheck -r [database] // Replace database name with your database name.


Repair MySQL Database through Windows Command Line

1. Log in to your Windows VPS using Remote Desktop. Please refer to how to connect Windows VPS using RDP.

2. Go to Start and locate Command Prompt. Right-click Command Prompt and select the Run as Administrator option.

3. At the Windows command prompt, navigate to the MySQL bin directory as follows.

cd C:\Program Files\MySQL\MySQL Server 5.5\bin // Replace your MySQL bin directory path here.

4. Run the following command to start the MySQL prompt.

mysql -u root -p

5. Enter MySQL root password when you are being asked.

6. You will see the MySQL prompt appearing. Now, to display all databases, type the following command at mysql prompt:

show databases;

7. Enter the following command to repair the MySQL database.

mysqlcheck -r [database] // Replace database name with your database name.


Was this answer helpful?

« Back

chat

/* */