Database syncing with Craft CMS

# Install and deploy run down

1. Install Craft CMS locally
2. Setup an app at fortrabbit
3. Deploy code via Git
4. Database syncing ← you are here
5. Assets syncing

# Database configuration setup

In most cases, the Craft CMS installation on fortrabbit can already connect to the remote MySQL database through pre-populated environment variables.

But when initially installing Craft CMS on your fortrabbit environment, after Git deployment or SFTP upload your database is still missing. In most cases you want to import your local database now, to have database content and structure up.

Visit the MySQL import/export guides to learn how to sync the database up and down using different techniques.

# Database up

1. Export the local database
2. Upload the dumped .sql file
3. Import the database dump into the app environment database

• Database up via terminal
• Database up via MySQL GUI

# Database down

As your project matures, you may want to download the database for local development.

1. Export the remote database
2. Download the dumped .sql file
3. Import the database in your local development

• Database down via terminal
• Database down via MySQL GUI