jasonglisson
9/15/2015 - 4:40 PM

Mysql - Dump database in terminal

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>'