Skip to content

Instantly share code, notes, and snippets.

@jasonglisson
Last active September 14, 2017 12:39
Show Gist options
  • Select an option

  • Save jasonglisson/48d5c3a532cfead1ccf9 to your computer and use it in GitHub Desktop.

Select an option

Save jasonglisson/48d5c3a532cfead1ccf9 to your computer and use it in GitHub Desktop.
Mysql - Dump database in terminal
mysqldump -h db-dev.usgs.mobomo.net -u dev_admin -pusgs2015 answers_drupal | mysql -h db-dev.usgs.mobomo.net -u dev_admin -pusgs2015 answers_jason
mysqldump -h db.palladium.usgs.mobomo.net -P 3306 dev -u usgs_admin -p'M0b0m0.U$g$2015' | mysql -h stage.db.palladium.usgs.mobomo.net stage -u dbadmin -p'M0b0m0.U$g$2015!'
mysqldump -h <database hostname> -P 3306 <database name> -u <database username> -p'<database password>' | mysql -h <database hostname> <database name> -u <database username> -p'<database password>'
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment