Skip to content

Instantly share code, notes, and snippets.

@cmpscabral

cmpscabral/mysql_dump_all.sh

Created December 29, 2015 19:13
Show Gist options
  • Save cmpscabral/4f64339008bcb4af6252 to your computer and use it in GitHub Desktop.
Save cmpscabral/4f64339008bcb4af6252 to your computer and use it in GitHub Desktop.
Download ZIP
dump and restore all databases
Raw
mysql_dump_all.sh
mysqldump -u root -p --opt --all-databases > alldb.sql
mysqldump -u root -p --all-databases --skip-lock-tables > alldb.sql
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment