Support » Networking WordPress » Backing up and restoring multisite blogs into separate databases, and back ?

  • Hello,

    My wife has multiple blogs installed under a single wordpress hood, with the multisite feature, I installed it for her with the release of wordpress 3.2.1, under the root/subfolder-blog format.

    We’re about to move her multisite blogs to another web host (a big move, from shared to dedi, I’m already hosting there several websites), and since I’m a heavily paranoid person, in addition to backing up the files and the whole database containing all the multi-blogs, I would really like to be able to backup each blog separately, as if it were a single blog.

    This way, if there are problems with the new web host (multi can be tricky with its server configuration as soon as we deal with Apache, seriously, and the results from my various test installations have been random, sometimes it worked, sometimes not), I can resort to separate installations for a little while.
    You know the proverb about having all the eggs inside the same basket.

    So, here’s my question, please,

    – is it possible to backup each of the multi-blogs into a separate database,

    – and is it possible to re-integrate a separate blog’s database into an existing multisite blog installation ?

    (and yes, I already searched, but found no valid solution, at best recommendations for export, with phpmyadmin, to rename wp_xxx_tables to just wp_ after saving to a new DB, blame my poor google-fu)

    Thank you VERY MUCH if you can tell me, this would be extremely useful to know !

    Best regards,

    (PS : I apologize, I had first posted my question in the wrong forum, please, could a moderator delete the wrong post ?)

Viewing 3 replies - 1 through 3 (of 3 total)
  • Moderator Ipstenu (Mika Epstein)


    🏳️‍🌈 Halfelf Rogue & Plugin Review Team Rep

    Post removed 😉 Next time tag it ‘modlook’ and we’ll move it for you.

    Short answer – Extracting a site from a Multisite network is not easy, and while you can get the post content out, you don’t get the theme settings, plugins etc.

    It’s actually much safer to pick up and move the whole thing as one.

    Well, thanks for the reply Ipstenu 🙂

    I think this would be a worthy development axis for WordPress in the future, to be able to break down a multisite back into separate blogs.

    Remember, WordPress is all about freedom given to the webmasters, this wonderful freedom to leave or wreck havoc, that, to the contrary, convinces us every day to gladly stick to wordpress and enjoy a stable web architecture.

    However, with the multisite feature, once we create a network, we have no other option but to stick to this, there’s no opting out, no easy quitting while getting our things with us.

    (And as a webmaster, I’m threatened, if ever something works differently with Apache – I’m new to dedis -, I’m screwed)

    This is a liability, in my opinion.

    Not technically a liability, but regarding the philosophy of wordpress, an actual liability.

    (Not trying to blame it on you, Ipstenu, I’m more likely hoping to bring value added to the future, if this opinion may catch more eyes some day !)

    Moderator Ipstenu (Mika Epstein)


    🏳️‍🌈 Halfelf Rogue & Plugin Review Team Rep

    *hand wave* Given what multisite grew out of, it’s not surprising that it grew this way (lookit – that’s Multisite in action). In that scenario, people on a Multisite aren’t the ones with access to the DBs (which may be why WP sells guided transfers…).

    I feel you, though, and hopefully this gets picked up as the goal for a future release.

Viewing 3 replies - 1 through 3 (of 3 total)
  • The topic ‘Backing up and restoring multisite blogs into separate databases, and back ?’ is closed to new replies.