Check tables of a MySQL database and repair corrupt

I am one of those who likes to be aware of the servers that I manage, although they are highly stable, it never hurts to always keep an eye on them, as the saying goes:

The eye of the master fattens the horse

From time to time it is good to do several checks on the server and its services, in this case I will talk about how to check the tables of a database and in case one is corrupt, how to repair it.

Check the tables of a MySQL DB

As for everything (or almost everything), there is a fairly simple command that allows us to check all the tables in a MySQL database:

mysqlcheck --check BASE_DE_DATOS --user="USUARIO" --password="PASSWORD"

For example, suppose I have a database called: project thesis

My MySQL administrator user is: root

And the password of that user is: misuperpassword

So the line would be:

mysqlcheck --check proyectotesis --user="root" --password="misuperpassword"

It would show something like:

dfirefoxos.wp_commentmeta OK dfirefoxos.wp_comments OK dfirefoxos.wp_links OK dfirefoxos.wp_options OK dfirefoxos.wp_postmeta OK dfirefoxos.wp_posts OK dfirefoxos.wp_term_relationships OK dfirefoxos.wwwp_term_firefox OK dfirefoxos.wp_termtermsfirefoxfirefox_wp_term_fireosfirefox_wpfoxosponomy_term_postsfirefoxfirefox_term_relationships OK_wpfoxosfirefox_term_relationshipsfirefox OK_wp_term_fireosfirefox_wpfoxospfoxonwp_term_

In other words, all the tables are right now.

How to repair a table in case it appears as corrupt?

I already made a post explaining this in detail: How to Repair Tables Marked Bad or Corrupt in MySQL

However, I will leave the steps here.

1. First we must enter MySQL through terminal:

mysql -u root -p

It will ask us for the root password, we put it and press [Enter].

2. Then we must indicate which database we will use, that is, which is the database that has the corrupted table. Following the example at the beginning, let's say the database is: project thesis

use proyectotesis;

And now we tell it to repair the corrupt table, for example let's say the table is called: public_information

Would:

repair table public_information;

And voila, this should be enough to repair it in most cases.

I hope it is useful to you ... and that you never have corrupt tables 😀