Comment on page
Import database dump
Imports database dump into MySQL container.
Note 1: To be able to import a database dump application must be running.
Note 2: It is recommended to run the start command after running database import to ensure that configuration is up-to-date.
Imports database from the remote server.
Currently, the following protocols are supported:
ssh://
yarn
npm
yarn import-db --remote-db ssh://[email protected]
npm run import-db -- --remote-db ssh://[email protected]
Now it will connect via ssh to your server, create dump files (
dump-0.sql
and dump-1.sql
), download them to your projects root folder, merge them into single dump.sql
and import to your local instance with applied fixes.To learn more about this option, read the following guide:
Does not exclude customers and orders data when importing local and remote database.
yarn
npm
yarn import-db ./dump.sql --with-customers-data
yarn import-db --remote-db ssh://[email protected] --with-customers-data
npm run import-db ./dump.sql -- --with-customers-data
npm run import-db -- --remote-db ssh://[email protected] --with-customers-data
If you are importing a remote database and using this option, CMA will create only one
dump.sql
file with all data inside it.yarn import-db ./dump.sql
... # output
# or with npm
npm run import-db ./dump.sql
... # output
Last modified 1yr ago