Database up via terminal
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 developments based on containers may require some extra steps, like logging in to the MySQL container or executing commands on the container.
- 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