Differences

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

--- unix:mysql [2021-04-28T11:12:58+0200]
Wolfgang
+++ unix:mysql [2021-08-25T18:57:47+0200]
Wolfgang [Compressed MySQL-Dump]
@@ Line 34: / Line 34: @@
 <code>
-database=schema-name; mysqldump --routines --opt --single-transaction --quick --databases $database | gzip > $(hostname)-$database-$(date +%F_%s).sql.gz
+database=schema-name; mysqldump --default-character-set=utf8mb4 --no-tablespaces --routines --opt --single-transaction --quick --databases $database | gzip > $(hostname)-$database-$(date +%F_%s).sql.gz
 </code>
 <code>
-mysqldump --routines --opt --single-transaction --quick --all-databases | gzip > $(hostname -f)-$(date +%F_%s).sql.gz
+mysqldump --default-character-set=utf8mb4 --no-tablespaces --routines --opt --single-transaction --quick --all-databases | gzip > $(hostname -f)-$(date +%F_%s).sql.gz
 </code>
 ===== Create Database with UTF8 collation  =====