Dev -> Staging -> Production database syncing? (6 posts)

  1. fhsm
    Posted 5 years ago #

    I've recently inherited a odd sort of wordpress 3.0.1 multisite intranet project. I'm new to WP but not LAMP development.

    So far I've found it a bit frustrating. How do WP pros keep local, staging and development site configs in sync? The source is easy, but all of the setup that is locked away in the database commingled with domain specific options is not.

  2. danielwiener
    Posted 5 years ago #

    I have found this very frustrating as well. It seems like a flaw that wordpress writes the full url for images, etc. into the database, instead of a path relative to the root.

    Here are a couple of sites that suggest ways of syncing local and remote sites. (I am still looking for something better.)



    hope this helps a little.

  3. Xephan
    Posted 5 years ago #

    My workaround to that is to use the same domain names on my development setup, then just playing around with two copies of the hosts file by using a script to switch between the two for checking the live site and for working on the dev site.

    Admittedly every now and then I forget to switch and things get confused for a moment. But it does make dumping the sql data easier.

  4. fhsm
    Posted 5 years ago #

    Thanks for the tips.

    I'm working w/ a multisite network that runs over SSL. Moving it to localhost isn't going to be as easy as the dev/stage/deploy cycle of a drupal site. I've just had to set up a DNS server on my LAN. Hard to believe that's really the easiest way around the problem but I think it is.

  5. Snaky Love
    Posted 4 years ago #

    fhsm, could you please describe your dev cycle in detail, that would be very interesting, thanks!

    Anybody tried one or both of these plugins:
    Dev and Staging Environment Plugin


    Would like to read about your experiences, as I am trying to build a sane wordpress dev and deployment environment... for me that means I want git as a backend, rsync or git push / pull mechanism for file sync across servers and database migrations - yes, I would like to UNDO any deployment step or change to different versions / tags easily.

    I added some TAGS to this thread so more people can find it - you should always use tags here!

    Have a nice day!

  6. danielwiener
    Posted 4 years ago #

Topic Closed

This topic has been closed to new replies.

About this Topic