Simple plugin to synchronize a Heroku remote MySQL database to a local MySQL database, and vice versa. Optional search and replace capabilities are included and provided by Search-Replace-DB. Both ClearDB and JawsDB Heroku add-ons are supported.
heroku plugins:install https://github.com/josepfrantic/heroku-mysqldump
All commands accept Heroku's --app <heroku_application_name> convention.
By default the plugin assumes either ClearDB or JawsDB add-on is in use, but not both. In case of having both add-ons indicate which one you want to use with the --db parameter (Values accepted: cleardb / jawsdb).
Note: The plugin will overwrite existing database contents, and cannot be undone. You are encouraged to take a database backup before running mysql:push to production environments.
heroku mysql:pull <local_database_name or MySQL DSN string>
heroku mysql:pull test --app my-heroku-app
heroku mysql:pull mysql://foo:bar@localhost/test --app my-heroku-app
heroku mysql:pull <local_database_name | MySQL DSN string> --search mysite.herokuapp.com --replace localhost:5000
heroku mysql:push <local_database_name | MySQL DSN string>
heroku mysql:push <local_database_name | MySQL DSN string> --search localhost:5000 --replace mysite.herokuapp.com
heroku mysql:dump 2>/dev/null > project_production_$(date +"%F_%H%M").sql
Note: Make sure to check the backup since errors are silenced from the output.
Note 2: 2>/dev/null is used to discard STDERR stream (for example Heroku warnings) which would end up to the output and therefore break the actual MySQL dump file. Again, please do check the dump.
Note 3: --search and --replace are not supported in mysql:dump. In such case, use mysql:pull (with search & replace) and manually run mysqldump locally afterwards.