Mysql/MariaDB

check/fix errors in a mysql/mariaDb database

• use the tool mariadb-check
  • it should be installed by default if you have an installed mariadb

mariadb-check --all-databases --check --password
mariadb-check --all-databases --repair --password

start mysql command line

mysql -p

show databases

show databases;

show engines

show engines;

show engine per table

If you know your database names, you can look for the tables in the databases and their engines:

select table_name, table_schema, engine from information_schema.tables where table_schema like "YOURDATABASE%";

Use '%' instead of '*' if you want a wildcard.

select table_name, table_schema, engine from information_schema.tables where table_schema like "YOURDATABASE%" and not engine="InnoDB";