How to check databases

Questions regarding the Database Server
MySQL, PostgreSQL, MariaDB, Percona Server, phpMyAdmin, phpPgAdmin
Forum rules
Before creating a new topic or reply on the forum you should fill out additional fields "Os" and "Web" in your profile section.
In case of violation, the topic can be closed or response from the support will not be received.
VestaCP Team
Posts: 7808
Joined: Fri Dec 26, 2014 2:23 pm

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 1 guest