Data Integrity

By Selwyn Polit, 25 August, 2021

Recently I suspected I had a problem in my mysql databases on my webserver, so I ran the following command:

mysqlcheck -u root -p'put-your-database-password-here' --all-databases

I got a neat list of databases and tables and messages saying some tables are OK and some not. Notice that I cleverly replaced my database root password with the phrase put-your-database-password-here, so you should replace that with your password if you want to try this.  BTW it seems you can ignore the warnings about client using or not closing tables.