Database syncing

[paul_tibbetts]

@Aggressive

Is there a guide that you know of to show examples of steps involved?

@cfx

You can also use the forum’s search feature to read threads that have already addressed this

I’ve written up how you can use WP-CLI and SCP/rsync to keep production and staging in sync here:

Local > Staging > Deploy Setup Help

Hey @uberaff, welcome to Roots! If I understand correctly, you’d like to have a staging site on, say, staging.example.com with the same code and database as production. First, you’ll need the IP of the staging server added to hosts/staging under both [staging] and [web]. Next, add your site details to staging/wordpress_sites.yml. If you’ve already configured it for production you can copy and paste this over. Remember to also modify the vault.yml file with the name of your site. site_hosts c…