Differences
This shows you the differences between two versions of the page.
Both sides previous revision Previous revision | |||
de:server:services:mariadb [2023/01/06 18:55] – [Datenbank sichern] changed dump all database comand and added single dump database command dan | de:server:services:mariadb [2023/02/14 21:44] (current) – switched to mariadb-* instead of mysql* dan | ||
---|---|---|---|
Line 191: | Line 191: | ||
< | < | ||
- | mysql_upgrade -u root -p --skip-version-check | + | systemctl restart mariadb.service |
</ | </ | ||
< | < | ||
- | systemctl restart | + | mariadb-upgrade -u root -p |
- | </ | + | </ |
Um alle Tabellen in allen Datenbanken zu prüfen: | Um alle Tabellen in allen Datenbanken zu prüfen: | ||
< | < | ||
- | mysqlcheck | + | mariadb-check |
</ | </ | ||
Um alle Tabellen in allen Datenbanken zu analysieren: | Um alle Tabellen in allen Datenbanken zu analysieren: | ||
< | < | ||
- | mysqlcheck | + | mariadb-check |
</ | </ | ||
Um alle Tabellen in allen Datenbanken zu reparieren: | Um alle Tabellen in allen Datenbanken zu reparieren: | ||
< | < | ||
- | mysqlcheck | + | mariadb-check |
</ | </ | ||
Um alle Tabellen in allen Datenbanken zu optimieren: | Um alle Tabellen in allen Datenbanken zu optimieren: | ||
< | < | ||
- | mysqlcheck | + | mariadb-check |
</ | </ | ||
Alle Befehle " | Alle Befehle " | ||
< | < | ||
- | mysql_upgrade -u root -p --skip-version-check | ||
systemctl restart mariadb.service | systemctl restart mariadb.service | ||
- | mysqlcheck | + | mariadb-upgrade -u root -p |
- | mysqlcheck | + | mariadb-check |
- | mysqlcheck | + | mariadb-check |
- | mysqlcheck | + | mariadb-check |
+ | mariadb-check | ||
</ | </ |