Skip to content

Instantly share code, notes, and snippets.

@grimzy

grimzy/MySQL

Created July 12, 2017 13:34
Show Gist options

  • Select an option

    Learn more about clone URLs
  • Save grimzy/35d92bbe7c5822f0523fe77a39eed484 to your computer and use it in GitHub Desktop.

Select an option

Learn more about clone URLs
Save grimzy/35d92bbe7c5822f0523fe77a39eed484 to your computer and use it in GitHub Desktop.
Download ZIP

Revisions

  1. grimzy created this gist Jul 12, 2017.
    1 change: 1 addition & 0 deletions MySQL
    View file
    Original file line number Diff line number Diff line change
    @@ -0,0 +1 @@
    mysqldump -h <source_host> -u <source_user> <source_db> | mysql -h <destination_host> -u <destination_user> <destination_db>
    1 change: 1 addition & 0 deletions PostgreSQL
    View file
    Original file line number Diff line number Diff line change
    @@ -0,0 +1 @@
    pg_dump -h <source_host> -U <source_user> <source_db> | psql -h <destination_host> -U <destination_user> <destination_db>