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