How to check databases

Sometimes it happens that the database is broken. For repair and verification you can use following set of commands:

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

 

You may also like...

Bir yanıt yazın