grimzy/MySQL

Created July 12, 2017 13:34

Star () You must be signed in to star a gist
Fork () You must be signed in to fork a gist

Learn more about clone URLs
Clone this repository at <script src="https://gist.github.com/grimzy/35d92bbe7c5822f0523fe77a39eed484.js"></script>
Save grimzy/35d92bbe7c5822f0523fe77a39eed484 to your computer and use it in GitHub Desktop.

Download ZIP

Copy database

Raw

MySQL

mysqldump -h <source_host> -u <source_user> <source_db> | mysql -h <destination_host> -u <destination_user> <destination_db>

Raw

pg_dump -h <source_host> -U <source_user> <source_db> | psql -h <destination_host> -U <destination_user> <destination_db>

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment