Migrate your Strapi app from Heroku to AWS

12min

One-click Deploy﻿﻿
Click the Deploy with Microtica button below and follow the template steps to migrate your existing Strapi application from Heroku to your AWS account.
<p style="margin: -70px 0 -40px 0">
    <a target="_blank" href="https://app.microtica.com/templates/new?template=https%3A%2F%2Fraw.githubusercontent.com%2Fmicrotica%2Ftemplates%2Fmaster%2Fimport-app%2Ftemplate.yaml&import=true&utm_source=docs&utm_medium=one_click_deploy_button&utm_campaign=migrate_strapi_from_heroku">
        <img src="https://microtica.s3.eu-central-1.amazonaws.com/assets/templates/logos/deploy-with-microtica.svg" alt="Deploy with Microtica" width="180px" />
    </a>
</p>
<p style="margin: -70px 0 -40px 0">
    <a target="_blank" href="https://app.microtica.com/templates/new?template=https%3A%2F%2Fraw.githubusercontent.com%2Fmicrotica%2Ftemplates%2Fmaster%2Fimport-app%2Ftemplate.yaml&import=true&utm_source=docs&utm_medium=one_click_deploy_button&utm_campaign=migrate_strapi_from_heroku">
        <img src="https://microtica.s3.eu-central-1.amazonaws.com/assets/templates/logos/deploy-with-microtica.svg" alt="Deploy with Microtica" width="180px" />
    </a>
</p>
﻿
This is a step-by-step tutorial on how to migrate your existing Strapi project from Heroku to AWS, using Microtica’s ready-made Strapi infrastructure template. This guide applies to developers that have a running application on Heroku with PostgreSQL or MySQL database and covers:
Setup of Strapi infrastructure on AWS
Migrating PostgreSQL/MySQL database from Heroku to AWS
If you don’t have an existing Strapi project on Heroku, here is a guide on how to deploy a new Strapi Application on your AWS account.
Before we get started, please make sure you:
Have access to your Heroku account and CLI
﻿Create a Microtica account﻿
1. Setup Strapi infrastructure on AWS
To setup the serverless infrastructure for your existing Strapi application please follow the Deploy an Existing Strapi App guide.
When configuring the template make sure that you select postgres or mysql as DatabaseClient.
Once the infrastructure is deployed and ready (which should be in about 10 minutes), you can proceed with migrating your existing data from Heroku to AWS.
2. Migrate database from Heroku to AWS
Download all data from the Heroku database locally
To export the data from your Heroku Postgres database, create a new backup and download it, using the following commands: 
PostgreSQL
|
heroku pg:backups:capture --app example-app
heroku pg:backups:download --app example-app
heroku pg:backups:capture --app example-app
heroku pg:backups:download --app example-app
﻿
To export the data from your Heroku MySQL database, dump the Heroku database on your local development environment using mysqldump tool.
MySQL
|
mysqldump --set-gtid-purged=OFF --single-transaction -hHOST_HERE -uUSER_HERE -P PORT_HERE -p DB_NAME_HERE > heroku_db

# --set-gtid-purged=OFF - required property for RDS because you don’t have full permission in RDS.
# --single-transaction – Use to ensure that all of the data loaded from the local database is consistent with a single point in time. If there are other processes changing the data while mysqldump is reading it, using this option helps maintain data integrity.
# -h - hostname of the DB. No space between -h and the value.
# -u – Use to specify a user name. No space between -u and the value.
# -P - mysql port
# -p - once the command is run you’ll be asked for the DB password
# DB_NAME_HERE - the name of the database you want to download locally
mysqldump --set-gtid-purged=OFF --single-transaction -hHOST_HERE -uUSER_HERE -P PORT_HERE -p DB_NAME_HERE > heroku_db

# --set-gtid-purged=OFF - required property for RDS because you don’t have full permission in RDS.
# --single-transaction – Use to ensure that all of the data loaded from the local database is consistent with a single point in time. If there are other processes changing the data while mysqldump is reading it, using this option helps maintain data integrity.
# -h - hostname of the DB. No space between -h and the value.
# -u – Use to specify a user name. No space between -u and the value.
# -P - mysql port
# -p - once the command is run you’ll be asked for the DB password
# DB_NAME_HERE - the name of the database you want to download locally
﻿
If you get this error message "Unknown table 'COLUMN_STATISTICS' in information_schema", add the command --column-statistics=0. The command adds ANALYZE TABLE statements to the output to generate histogram statistics for dumped tables when the dump file is reloaded.
If you get this error message "Access denied; you need (at least one of) the PROCESS privilege(s) for this operation", add the command --no-tablespaces. The suppresses all CREATE LOGFILE GROUP and CREATE TABLESPACE statements in the output of mysqldump.
Connect to Amazon RDS database
To establish a connection between your local development environment and AWS please follow the Access the RDS database guide.
Once the connection is established, you can proceed with moving the local copy of the data to AWS.
Move local database copy to AWS
Load the dump into your Amazon RDS PostgreSQL using the pg_restore tool.
PostgreSQL
|
pg_restore --verbose --clean --no-acl --no-owner -h localhost -U dbuser -d strapi latest.dump
pg_restore --verbose --clean --no-acl --no-owner -h localhost -U dbuser -d strapi latest.dump
﻿
Load the dump into your Amazon RDS MySQL database using the ﻿﻿mysql tool.
MySQL
|
mysql -udbuser -h localhost -P 3306 -p strapi < heroku_db
mysql -udbuser -h localhost -P 3306 -p strapi < heroku_db
﻿
﻿