How to check databases

[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