How to check databases

Questions regarding the Database Server
MySQL, PostgreSQL, MariaDB, Percona Server, phpMyAdmin, phpPgAdmin
skurudo
VestaCP Team
Posts: 7791
Joined: Fri Dec 26, 2014 2:23 pm
Location: Moscow
Contact:

How to check databases

Postby skurudo » 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
-> DigitalOcean competition - please, support us
-> fix for phpmyadmin - nice and sweet now

Return to “Database Server”



Who is online

Users browsing this forum: No registered users and 2 guests

cron