Wednesday 18 December 2019

How To Check And Repair All MySQL Databases on Debian And Ubuntu Linux

The Following command can be used to check and repair all MySQL databases on a Ubuntu or Debian Linux System.
Ubuntu Linux
sudo mysqlcheck --defaults-file=/etc/mysql/debian.cnf --auto-repair --optimize --all-databases
Debian Linux
mysqlcheck --defaults-file=/etc/mysql/debian.cnf --auto-repair --optimize --all-databases
The benefit of the above command is that it uses the debian-sys-maint login to MySQL which is available on every Debian and Ubuntu System, so you don't have to provide the MySQL root login details.

1 comment:

  1. According to Stanford Medical, It is really the one and ONLY reason women in this country live 10 years more and weigh an average of 42 lbs lighter than us.

    (And by the way, it really has NOTHING to do with genetics or some secret diet and absolutely EVERYTHING to do with "HOW" they eat.)

    BTW, What I said is "HOW", not "WHAT"...

    TAP this link to discover if this quick test can help you decipher your real weight loss possibility

    ReplyDelete