en:server:services:mariadb

Differences

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

Link to this comparison view

Both sides previous revision Previous revision
Last revisionBoth sides next revision
en:server:services:mariadb [2022/10/24 08:24] – external edit 127.0.0.1en: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 ===== ===== 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: Or use the following script, which contains:
  • en/server/services/mariadb.txt
  • Last modified: 2023/02/14 21:42
  • by dan