Pulling WordPress Options or Entire database crashes live site

I’ve managed to fix my original issues by starting over with the setup instructions. This time I followed the “How to setup SitePush in a multiple vhost environment” instructions which come first on the Server Setup page: ( https://www.ads-software.com/extend/plugins/sitepush/other_notes/ ) and the live site no longer crashes after a WordPress options pull.

However, the problem I have now is that after a WordPress options pull from Staging to Live, the Live site options for siteurl, home, and fileupload_url are all getting overwritten with the Staging site values. Once I go in and update those three fields in the database it’s back to normal. I’m wondering what I’m still doing wrong as far as the settings.

Thanks!

Try defining WP_HOME and WP_SITEURL in your wp-configs – that way you can have them set to different things for live and staging sites, assuming you are not using a single site WP install.

That did the trick.

The only issue now is when I look at the live website database within phpMyAdmin the values within wp_options for blogname, siteurl, and home are all staging values. The wp-config settings have hard coded values for siteurl and home so it’s really no big deal, as long as the blogname (Site Title) values are the same between staging and live.

Since my siteurl and home values within the live database are showing the staging values, do I still have something wrong with my setup, or is this how it should work?

By the way I do have separate sites for both live and staging, each within their own directories.

Thanks for your help!

The WP_HOME and WP_SITEURL constants override whatever is in the database, so if the constants are set correctly it doesn’t really matter what is in the database for those options.