Let's see how to 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, run this command to check the desired database:

mysqlcheck -r [your-database-name]

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


3.  In case, if the above command does not work, you can use "myisamchk" command:

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

where,
myisamchk command is the default storage engine for MySQL and will check the database.
-r will repair the corrupted tables of the database.
Je li Vam ovaj odgovor pomogao? 0 Korisnici koji smatraju članak korisnim (0 Glasovi)