Database up via terminal

• Database access intro
• Database export/import intro
• How to connect to the remote database via terminal

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.sql command to export a database
  • ddev auth - login to the container (first)
  • ddev exec … - execute a command