Comment on page
Importing remote database
Currently, only SSH protocol is supported!
CMA will connect via ssh to your server, create 2 dump files (
dump-1.sql), download them to your projects root folder, merge them into single
dump.sqland import to your local instance with applied fixes.
There is a good reason for it! The dump file created by this command is much smaller than dump files that are created the usual way. This is because we omit orders and customers data when we're creating dump file so it comes in a much smaller size.
For example, a dump from a database could weigh 2.7GB, now using this import feature size will be reduced to 4MB.
The reason to make 3 dump files is simple: mysqldump utility cannot make dump files with only a few tables without data, --no-data option is a boolean so we have only 2 options, either include data or not.
dump-0.sqlfile contains all the database tables with data, except for the order and customer-related tables.
dump-1.sqlfile contains only orders and customer-related table structures, without data.
dump.sqlfile is made from concatenating
dump-1.sql, which are downloaded from your remote server, so it's a full dump file.