Mysql/MariaDB: Difference between revisions
From Andreida
(Created page with "=== check/fix errors in a mysql/mariaDb database === * use the tool [https://mariadb.com/kb/en/mariadb-check/ 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") |
No edit summary |
||
| Line 4: | Line 4: | ||
mariadb-check --all-databases --check --password |
mariadb-check --all-databases --check --password |
||
mariadb-check --all-databases --repair --password |
mariadb-check --all-databases --repair --password |
||
=== start mysql command line === |
|||
mysql -p |
|||
=== show databases === |
|||
show databases; |
|||
=== show engines === |
|||
show engines; |
|||
Revision as of 22:01, 24 January 2025
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;
