Skip to content

Instantly share code, notes, and snippets.

@basselin
Last active December 14, 2015 21:45
Show Gist options
  • Save basselin/42fa54e7d45f8f06b636 to your computer and use it in GitHub Desktop.
Save basselin/42fa54e7d45f8f06b636 to your computer and use it in GitHub Desktop.
mysql dump: Restore with MAMP
/Applications/MAMP/Library/bin/mysql --user="root" --password="root" --host="localhost" database < ~/Desktop/db.sql
gunzip < db.sql.gz | /Applications/MAMP/Library/bin/mysql --user="root" --password="root" --host="localhost" database
/Applications/MAMP/Library/bin/mysqldump --user="root" --password="root" test | gzip > test.sql.gz
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment