Database up via terminal
Reviewedbyfl
Export and upload your local MySQL database to fortrabbit using terminal commands
Get ready
Do
The following commands are run in your local development environment. mysql and mysqldump are required.
# Terminal 1
# Export database from your local machine
$ mysqldump --set-gtid-purged=OFF -u{{local-db-user}} -p {{local-db-name}} > dump.sql
# You'll be prompted for your local database password
# Open the SSH tunnel
ssh -N -L 13306:mysql:3306 {{app-env-id}}@ssh.{{region}}.frbit.app
# No output. Open a new terminal window!
shell
# Terminal 2 (new window)
# Import Database
mysql -h127.0.0.1 -P13306 -u{{app-env-id}} -p {{app-env-id}} < dump.sql
# You'll be prompted for your MySQL password (found in the dashboard).
# The `dump.sql` file is from the first step.
# Can take a while, depends on size.
shell
Development environments
Local development environments based on containers may require additional steps, like logging in to the MySQL container or executing commands within it.
- Docker
docker exec -i {container} …- execute a command
- DDEV
ddev export-db > dump.sqlcommand to export a databaseddev auth- login to the container (first)ddev exec …- execute a command