MARIADB-CHECK(1) MariaDB Database System MARIADB-CHECK(1) (NAME) mariadb-check - ( mariadb- check mariadb-check ) (SYNOPSIS) mariadb-check [options] [db_name [tbl_name ...]] (DESCRIPTION) mariadb-check : . READ . . --databases --all-databases mariadb-check . ( mariadb-upgrade mariadb-check .) mariadb-check myisamchk . mariadb-check mariadbd myisamchk . mariadb-check . mariadb-check SQL CHECK TABLE REPAIR TABLE ANALYZE TABLE OPTIMIZE TABLE . . MyISAM mariadb-check MyISAM . . . test.t MEMORY : shell> mariadb-check test t test.t note : The storage engine for the table doesn't support check mariadb-check MariaDB . InnoDB CHECK TABLE REPAIR TABLE . mariadb-check (partitioned) . . . mariadb-check : shell> mariadb-check [options] db_name [tbl_name ...] shell> mariadb-check [options] --databases db_name ... shell> mariadb-check [options] --all-databases db_name --databases --all-databases . mariadb-check . (--check) . mariadb-check mariadb-repair mariadb-check mariadb-repair . mariadb-repair . mariadb-check . +---------------+-----------------------+ |mariadb-repair | | | | | | | --repair | +---------------+-----------------------+ |mysqlanalyze | | | | | | | --analyze | +---------------+-----------------------+ |mysqloptimize | | | | | | | --optimize | +---------------+-----------------------+ mariadb-check [mariadb-check] [client] . -c -r -a -o ( ). o --help, -? . o --all-databases, -A . --databases . o --all-in-1, -1 . o --analyze, -a . o --auto-repair . . o --character-sets-dir=path . o --check, -c . . o --check-only-changed, -C . o --check-upgrade, -g CHECK TABLE FOR UPGRADE . --fix-db-names --fix-table-names . o --compress . o --databases, -B . mariadb-check . . o --debug[=debug_options], -# [debug_options] . debug_options 'd:t:o,file_name' . 'd:t:o' . o --debug-check . o --debug-info (CPU) . o --default-auth=name . o --default-character-set=charset_name charset_name . o --defaults-extra-file=filename filename . . o --defaults-file=filename filename . . o --extended, -e . (keycache) . o --fast, -F . o --fix-db-names MySQL 5.1 . . o --fix-table-names ( ) MySQL 5.1 . . o --flush, (Flush) . (cache) . o --force, -f SQL . o --host=host_name, -h host_name MariaDB . o --medium-check, -m --extended . . . o --no-defaults . . o --optimize, -o . o --password[=password], -p[password] . (-p) . password --password -p mariadb-check . . . o --persistent, -Z ANALYZE TABLE PERSISTENT FOR ALL . o --pipe, -W (named pipe). named-pipe . o --plugin-dir=name . o --port=port_num, -P port_num TCP/IP . --protocol=tcp . o --print-defaults . . o --process-tables . --skip-process-tables . o --process-views=val ( CHECK VIEW REPAIR VIEW). NO YES ( checksum mariadb-version) UPGRADE_FROM_MYSQL ( YES MERGE<->TEMPTABLE). o --protocol={TCP|SOCKET|PIPE|MEMORY} . . o --quick, -q . . (index tree) . . o --repair, -r (unique keys) . o --silent, -s . . o --skip-database=db_name ( ) . o --socket=path, -S path localhost (named pipe) . --protocol=socket --protocol=pipe . o --ssl SSL ( ). --skip-ssl. o --ssl-ca=name CA PEM ( OpenSSL --ssl ). o --ssl-capath=name CA ( OpenSSL --ssl ). o --ssl-cert=name X509 PEM ( OpenSSL --ssl ). o --ssl-cipher=name SSL ( OpenSSL --ssl ). o --ssl-key=name X509 PEM ( OpenSSL --ssl ). o --ssl-crl=name ( OpenSSL --ssl ). o --ssl-crlpath=name ( OpenSSL --ssl ). o --ssl-verify-server-cert <> (hostname) . . o --tables --databases -B. . o --use-frm MyISAM .frm (header) .MYI . o --user=user_name, -u user_name MariaDB . o --verbose, -v . . --verbose mariadb-check . --verbose . CHECK RENAME ALTER TABLE . o --version, -V . o --write-binlog ANALYZE TABLE OPTIMIZE TABLE REPAIR TABLE mariadb-check (binary log) . --skip-write-binlog NO_WRITE_TO_BINLOG . --skip-write-binlog (replication slaves) . (COPYRIGHT) Copyright 2007-2008 MySQL AB, 2008-2010 Sun Microsystems, Inc., 2010-2025 MariaDB Foundation . . . Free Software Foundation, Inc., 51 Franklin Street, Fifth Floor, Boston, MA 02110-1335 USA http://www.gnu.org/licenses . (SEE ALSO) MariaDB https://mariadb.com/docs . (AUTHOR) MariaDB (http://www.mariadb.org). MariaDB 11.8 5 March 2025 MARIADB-CHECK(1)