Differences

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

--- en:server:services:mariadb [2022/06/04 00:36] – [Check/update database] added restart mariadb 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>
-mysql_upgrade -u root -p --skip-version-check
+systemctl restart mariadb.service
 </code>
 <code>
-systemctl restart mariadb.service
+mysql_upgrade -u root -p
 </code>
 To check all tables in all databases:
@@ Line 221: / Line 219: @@
 All "Check/update database" commands in one block
 <code>
-mysql_upgrade -u root -p --skip-version-check
 systemctl restart mariadb.service
+mysql_upgrade -u root -p
 mysqlcheck --all-databases -u root -p -c
 mysqlcheck --all-databases -u root -p -a