Differences
This shows you the differences between two versions of the page.
Both sides previous revision Previous revision Next revision | Previous revision | ||
en:server:services:mariadb [2022/05/30 09:28] – [Backup database] added crontab and changed the script info dan | en:server:services:mariadb [2023/02/14 21:42] (current) – [Check/update database] switched to mariadb-* instead of mysql* dan | ||
---|---|---|---|
Line 101: | Line 101: | ||
===== Backup database ===== | ===== Backup database ===== | ||
- | You can dump all databases with the following command '' | + | You can dump all databases with the following command '' |
- | '' | + | |
Or use the following script, which contains: | Or use the following script, which contains: | ||
Line 186: | Line 185: | ||
Upon a major version release of mariadb (for example mariadb-10.7.4-1 to mariadb-10.8.3-1), | Upon a major version release of mariadb (for example mariadb-10.7.4-1 to mariadb-10.8.3-1), | ||
- | - keep the 10.7.4-1 database daemon running | + | - upgrade |
- | - upgrade | + | - restart |
- | - run mysql_upgrade (from the new package version) against the old still-running daemon. This will produce some error messages; however, the upgrade | + | - run mariadb-upgrade |
- | - restart the daemon, so the 10.8.3 daemon runs. | + | |
< | < | ||
- | mysql_upgrade | + | systemctl restart mariadb.service |
- | </ | + | </ |
+ | |||
+ | < | ||
+ | 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 --all-databases -u root -p -o | ||
+ | </ | ||
+ | |||
+ | All " | ||
+ | < | ||
+ | systemctl restart mariadb.service | ||
+ | mariadb-upgrade -u root -p | ||
+ | mariadb-check --all-databases -u root -p -c | ||
+ | mariadb-check --all-databases -u root -p -a | ||
+ | mariadb-check --all-databases -u root -p -r | ||
+ | mariadb-check | ||
+ | </ |