Import .gz mysql export file from Production Magento2 Cloud to Stage Magento2 Cloud

Question

I have a Magento2.4 commerce cloud and I need to dump the existing staging website database and then take an existing database dump I just made which is on production. var folder and get it imported into the Magento2 commerce cloud database.

I see a lot of posts talking about dumping a database but not alow of detail specifically on getting a commerce cloud database emptied and then importing a production database and then changing the base url etc in the database.

Any videos or tutorials anyone knows of?

Answer 1

Have you checked this for dump and import in the commerce cloud? https://experienceleague.adobe.com/docs/commerce-cloud-service/user-guide/develop/deploy/staging-production.html

Answer 2

Migrating a database from one environment to another can be a complex task, especially when dealing with a cloud environment like Magento Commerce Cloud.

https://devdocs.magento.com/guides/v2.4/migration/migration-tool-install.html

Answer 3

We just dump the database into a gz file in staging environment. and then move the gz file from staging to production. And then import the gz file into the database of production.

# export the database in staging
mysqldump -h 127.0.0.1 --user=db_user_name --password=db_password --single-transaction database_name  | sed -e 's/DEFINER[ ]*=[ ]*[^*]*\*/\*/' | gzip > /tmp/db_dump.sql.gz

# import the db_dump.sql.gz into the database in production
zcat /tmp/db_dump.sql.gz | sed -e 's/DEFINER[ ]*=[ ]*[^*]*\*/\*/' | mysql -h 127.0.0.1 -u db_user_name -p db_password