The following command can be used to check and repair all MySQL databases on a Ubuntu or Debian Linux System. I’ve tested the commands on Ubuntu 20.04 and Debian 10.
sudo mysqlcheck --defaults-file=/etc/mysql/debian.cnf --auto-repair --optimize --all-databases
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.
The post Check and Repair All MySQL Databases on Ubuntu appeared first on FAQforge.
Welcome to the Ubuntu Weekly Newsletter, Issue 909 for the week of September 7 –…
Today Canonical, the publisher of Ubuntu, announced support for the NVIDIA CUDA toolkit and the…
For user with NVIDIA graphics card, Ubuntu finally added official NVIDIA 580 driver packages for…
Visual Studio Code 1.104, the August release of Microsoft’s code editor, was released few days…
For GNOME users who don’t like the default workspace switch animation, here’s an extension that…
Warzone 2100, the free open-source 3D real-time strategy game, released new major 4.6.0 version few…