First, download what you need via VaultPress and then merge the files with the following command in the terminal. (It helps to name
filename.sql to the database name you are going to import to).
cat *.sql > filename.sql
If you don’t want to overwrite the current database, comment out the previous one and create a new one in
# define( 'DB_NAME', 'databasename' );
# define( 'DB_NAME', 'databasename_preprod' );
define( 'DB_NAME', 'databasename_2023-03-19' );
Place the file you downloaded in the WordPress root folder (where
wp-config.php is, i.e. ‘above’ the
wp-content folder etc.).
(If you are using Local for your local site environment, you may need to access the terminal via the menu option in there, rather than the regular Terminal app, for the following commands to work).
If you want to overwrite an existing database you will need to drop it first. With wp-cli installed, run the following command from the WordPress root folder:
wp db drop
wp db create
wp db import
wp search-replace livesite.com localsite.test
Or for preprod sites:
wp search-replace www-preprod-url-vip.net localsite.test