Page 1 of 1

How to check databases

Posted: Mon Mar 20, 2017 1:57 pm
by skurudo
Sometimes it happens that the database is broken. For repair and verification you can use following set of commands:

Code: Select all

mysqlcheck --no-defaults -u root -p --all-databases
mysqlcheck --no-defaults -u root -p --all-databases -o
mysqlcheck --no-defaults -u root -p --all-databases --auto-repair
mysqlcheck --no-defaults -u root -p --all-databases --analyze