Multisite Install – But Single Site Migration

I’ve got three servers. One’s for local dev, one for staging live testing and the last is the live environment.

Assuming I have all the domain / server stuff in place, what’s the best way to migrate a single site from one server to the next.

Currently to go from Dev > Staging I’m doing an entire database export and SVN of the whole project. I need a way to just migrate a single site and everything within it as needed.

Also important to note that the url’s are slightly different ie; mywebsite.dev vs sta.mywebsite.com vs mywebsite.com

Have you got a suggested plugin or solution for this. I suspect it’s a common one for multi-site users.

Thanks.

Jay

CompuMatter

  • Jay
    • The Incredible Code Injector

    Hello,

    Thanks for writing back Patrick.

    My question to that is, assuming the site by the same name already exists on the target server, will this product recognize that it already exists and just overwrite the existing site or will it always default to creating a new site ?

    It is important for my particular needs that it update the existing when it exists.

    Your thoughts ?

    Jay

  • Jay
    • The Incredible Code Injector

    Hello,

    I think you misunderstood my question.

    I do not want it to create the new site. Although that would be nice. However, the most important goal is that it would recognize the site already exists and would it update the existing site content as this will be an ongoing issue.

    It appears by your answer that it would.

    Thanks.

    Jay

  • Patrick Cohen
    • Technical Docs Wrangler

    Hi again @Jay

    I hope you are well today!

    Yes, that will work.

    But there one caveat: Snapshot backs up your database tables. If you want to use it to keep your content updated by migrating from one site to the other, it’s important to realize that the import will overwrite existing files/content.

    So if, for example, there is a post on the destination site that doesn’t exist on your source site, importing from the source will overwrite what’s on the destination site and wipe out previous stuff.

    To prevent that when you want to update things on the destination site, first make a backup of the tables from the destination site and import that into your source site for editing. Then take a snapshot of that, and import it back into the destination site.

  • Jay
    • The Incredible Code Injector

    Patrick,

    Great. Sounds exactly what I’m looking for.

    Just to be clear…. will only migrate the 1 Site of my many multi-site installs and not the entire DB ?

    If so, I’m a very happy man. This will make life easier moving from the development server environment into the progressive server environments.

    Thanks so much.

    Jay

  • Patrick Cohen
    • Technical Docs Wrangler

    @Jay

    Just to be clear…. will only migrate the 1 Site of my many multi-site installs and not the entire DB ?

    Yep. As a matter of fact, that is currently a limitation of Snapshot, albeit a fortunate one in your use-case. Snapshot can backup a multisite install, but it must be done one site a ta time.

    You must identify which blog to backup when setting up your snapshot.

    [attachments are only viewable by logged-in members]