unix:mysql

Differences

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

Link to this comparison view

Both sides previous revision Previous revision
unix:mysql [2021-04-28T11:12:58+0200]
Wolfgang
unix:mysql [2021-08-25T18:57:47+0200] (current)
Wolfgang [Compressed MySQL-Dump]
Line 34: Line 34:
  
 <code> <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>
 <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> </code>
 ===== Create Database with UTF8 collation  ===== ===== Create Database with UTF8 collation  =====
  • unix/mysql.txt
  • Last modified: 2021-08-25T18:57:47+0200
  • by Wolfgang