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
Last revision Both sides next revision
unix:mysql [2020-11-06T21:34:58+0100]
Wolfgang
unix:mysql [2021-04-28T11:12:58+0200]
Wolfgang
Line 34: Line 34:
  
 <code> <code>
-database=schema-name; mysqldump --routines --opt --single-transaction --quick --databases $database | gzip > $(hostname)-$database-$(date +%FT%T%z).sql.gz+database=schema-name; mysqldump --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)-$(date +%s).sql.gz+mysqldump --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