Skip to content

Instantly share code, notes, and snippets.

@jrsouth

jrsouth/mysqldump_commands

Created October 29, 2013 15:31
Show Gist options
  • Save jrsouth/7216890 to your computer and use it in GitHub Desktop.
Save jrsouth/7216890 to your computer and use it in GitHub Desktop.
Download ZIP
MYSQL dump commands
Raw
mysqldump_commands
mysqldump --force --add-locks --single-transaction --quick --routines --extended-insert --log-error=mysqldump.error --databases lalrorg_live_drupal7 lalrorg_live_civicrm_audit lalrorg_live_civicrm | gzip -3 > live_snapshot_20131028_1552.sql.gz
mysqldump --force --single-transaction --quick --routines --extended-insert --log-error=mysqldump.error --databases lalrorg_live_drupal7 lalrorg_live_civicrm | gzip -3 > live_snapshot_20131029_1530_d7-civi.sql.gz
pv -p -t -e $DB_SNAPSHOT_CIVI | gzip -cd | mysql -u $USER -p$PASS $CIVI_DB
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment