Differences

This shows you the differences between two versions of the page.

--- en:server:services:mariadb [2022/05/30 09:28] – [Backup database] added crontab and changed the script info dan
+++ en:server:services:mariadb [2023/01/01 01:01] – [Backup database] changed dump all database comand and added single dump database command dan
@@ Line 101: / Line 101: @@
 ===== Backup database =====
-You can dump all databases with the following command ''mysqldump --single-transaction --flush-logs --master-data=2 --all-databases -u root -p | gzip > all_databases.sql.gz
+You can dump all databases with the following command ''mysqldump -u root -p %%--%%all-databases | gzip > all_databases.sql.gz'' or just one single database ''mysqldump -u root -p --databases database_name | gzip > database_name.sql.gz''.
-''.
 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), it is wise to upgrade databases:
-  - keep the 10.7.4-1 database daemon running
+  - upgrade the package(s)
-  - upgrade the package
+  - restart the daemon
-  - run mysql_upgrade (from the new package version) against the old still-running daemon. This will produce some error messages; however, the upgrade will succeed.
+  - run mysql_upgrade
-  - restart the daemon, so the 10.8.3 daemon runs.
+<code>
+systemctl restart mariadb.service
+</code>
 <code>
 mysql_upgrade -u root -p
 </code>
 To check all tables in all databases:
@@ Line 204: / Line 206: @@
 mysqlcheck --all-databases -u root -p -a
 </code>
 To repair all tables in all databases:
-`mysqlcheck --all-databases -u root -p -r`
+<code>
+mysqlcheck --all-databases -u root -p -r
+</code>
 To optimize all tables in all databases:
-`mysqlcheck --all-databases -u root -p -o`
+<code>
+mysqlcheck --all-databases -u root -p -o
+</code>
+All "Check/update database" commands in one block
+<code>
+systemctl restart mariadb.service
+mysql_upgrade -u root -p
+mysqlcheck --all-databases -u root -p -c
+mysqlcheck --all-databases -u root -p -a
+mysqlcheck --all-databases -u root -p -r
+mysqlcheck --all-databases -u root -p -o
+</code>