Database export/import
Options to upload a database from local to remote and downloading a database from remote to local.
# Get ready
Database import/export is a crucial task. Sync the state of a remote environment with a local environment. For that it requires:
- Have a local development environment running.
- Be able to access the remote fortrabbit database.
MySQL doesn't support incremental updates, so you'll always export the complete database structure and contents. This involves creating a dump.sql file from the source database and importing it to the destination database. The process works in both directions:
- Upload: Export from local and import to fortrabbit
- Download: Export from fortrabbit and import to local
During initial setup, you'll typically import your local database to fortrabbit at least once. Later, as content is added with the production environment, sync changes back to the local environment periodically.
Using mysqldump and mysql is the standard approach to migrate data between MySQL servers from the command line.
# Next
Depending on your local development environment setup and preferences, certain commands may differ.
Found a tpyo?Edit