A script to copy over a production database to another server, also has the ability to copy across imagery.
Currently the script is configured to attempt Magento 2 and WordPress database migrations and assumes you have your WordPress database details configured in the magento/app/etc/env.php file as a second connection named wordpress.
- You need curl installed locally.
- The excellent n98-magerun2 needs to be installed on both the local machine and the production machine. (Needs to be executable as n98-magerun).
- WP-CLI needs to be installed when working with WordPress as well.
- MySQL (or equivalent) needs to be installed on both the local machine and the server (obviously).
- Magento 2 needs to be installed and configured on both the local and the host machine.
- rsync needs to be installed locally.
- Magento URL's set in the env.php file
system.default.web.secure.base_url.
To install or update the script run the following curl script
curl -o- https://raw.githubusercontent.com/clivewalkden/bash-magento2-db-sync/master/install.sh | bash
To copy over a production database first get a shell on the system you want to copy the data to.
Notes: If using SSH to connect to the host machine make sure you've connected with the -A flag so that your ssh agent is forwarded to allow additional connections.
Execute the script in your Magento directory
$ db-sync.sh
You can save a configuration file in the Magento directory to save answering some of the questions. An example is included in this repository example.conf
remote_host=domain.com
remote_domain=www.domain.com
remote_port=22
remote_username=magento
remote_magento_dir=/opt/magento/magento2
remote_backup_dir=/opt/magento/backups
remote_shared_deployment_dir=/opt/magento/deployment/shared/magento
remote_php_path="/usr/bin/php"
remote_n98_path="/usr/local/bin/n98-magerun"
local_backup_dir=/opt/magento/backups
local_shared_deployment_dir=/opt/magento/deployment/shared/magento
local_file_user=magento
local_file_group=magento
ignore_tables="mageplaza_smtp_log"