Skip to content

Instantly share code, notes, and snippets.

@matstani
Last active May 30, 2021 14:42
Show Gist options
  • Save matstani/0cdceaaff26399533137fce1ddf21069 to your computer and use it in GitHub Desktop.
Save matstani/0cdceaaff26399533137fce1ddf21069 to your computer and use it in GitHub Desktop.
mysqldump -u user -p -h 127.0.0.1 --skip-lock-tables --single-transaction db | gzip > dump_`date +"%Y%m%d%H%M%S"`.sql.gz
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment