Differences
This shows you the differences between two versions of the page.
Both sides previous revision Previous revision | |||
en:server:services:mariadb [2023/01/01 01:01] – [Backup database] changed dump all database comand and added single dump database command dan | en:server:services:mariadb [2023/02/14 21:42] (current) – [Check/update database] switched to mariadb-* instead of mysql* dan | ||
---|---|---|---|
Line 187: | Line 187: | ||
- upgrade the package(s) | - upgrade the package(s) | ||
- restart the daemon | - restart the daemon | ||
- | - run mysql_upgrade | + | - run mariadb-upgrade |
< | < | ||
Line 194: | Line 194: | ||
< | < | ||
- | mysql_upgrade | + | mariadb-upgrade |
</ | </ | ||
To check all tables in all databases: | To check all tables in all databases: | ||
< | < | ||
- | mysqlcheck | + | mariadb-check |
</ | </ | ||
To analyze all tables in all databases: | To analyze all tables in all databases: | ||
< | < | ||
- | mysqlcheck | + | mariadb-check |
</ | </ | ||
To repair all tables in all databases: | To repair all tables in all databases: | ||
< | < | ||
- | mysqlcheck | + | mariadb-check |
</ | </ | ||
To optimize all tables in all databases: | To optimize all tables in all databases: | ||
< | < | ||
- | mysqlcheck | + | mariadb-check |
</ | </ | ||
Line 220: | Line 220: | ||
< | < | ||
systemctl restart mariadb.service | systemctl restart mariadb.service | ||
- | mysql_upgrade | + | mariadb-upgrade |
- | mysqlcheck | + | mariadb-check |
- | mysqlcheck | + | mariadb-check |
- | mysqlcheck | + | mariadb-check |
- | mysqlcheck | + | mariadb-check |
</ | </ |