How to check databases
Posted: Mon Mar 20, 2017 1:57 pm
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