Backup sub site

  • Hello,

    I have multisite installed on one of my domains, and I’ve been using the sub sites ( as sub directories ) for test sites when building WordPress themes.

    The problem I’ve gotten myself into, is that I used one of the sub sites to create an entire site. My origional intentions were to simply copy the db then dump it into the real site once completed.

    I have hundreds of posts in now, and have hundreds of contacts stored inside the wordpress business directory plugin and I’ve got profiles created inside the community builder Mingle Plugin.

    Now that I am close to being finished building the test site, I realize that moving this information will not be as easy as I assumed in the beginning, because the database is merged with all other sites on the network.

    I’ve tried db backups, and very weird things have happened.

    My question: How can I separate the sub site from all other sites on the multisite network so I can backup all data ( even data inside plugins ) then move it all to another WordPress installation that will NOT be a multisite setup.

Viewing 8 replies - 1 through 8 (of 8 total)

  • The sub sites does have separate tables in the db with it’s blog id in the prefix. So if it’s site number 23 in your sites list, all the wp_23_X tables belong to it.

    On the user end… that’s a little harder to extract out.

    The posts tho are easy. Use the Export menu. ??

    Thread Starter Josh M.

    (@ebiz_helper)

    Great – Thanks for that advice – here is my next question.

    I’ve located the tables wp_6_

    How do I export the data that has the wp_6_ then import it into regular wordpress database wp_ so it works correctly.

    I can use phpmyadmin

    Please forgive me if this question seems amateur – I don’t have advanced knowledge of Database admin.

    Your assistance is very much appreciated.

    Moderator Ipstenu (Mika Epstein)

    (@ipstenu)

    ?????? Advisor and Activist

    How do I export the data that has the wp_6_ then import it into regular wordpress database wp_ so it works correctly.

    Why not just use the WordPress export tool?

    Thread Starter Josh M.

    (@ebiz_helper)

    I want to get data from plugins, for example – all of the contacts inside the WordPress Business Directory plugin.

    There are also other plugins that I would like to export the data from.

    Moderator Ipstenu (Mika Epstein)

    (@ipstenu)

    ?????? Advisor and Activist

    In theory.

    1) Use phpMyAdmin to export all wp_6_* tables.
    2) EDIT the .sql file, changing wp_6_ to wp_
    3) Hope.

    OR, you could just copy ’em over to your new site and set the WP prefix to be wp_6 instead of wp …

    Though I don’t know how that would handle the users.

    Thread Starter Josh M.

    (@ebiz_helper)

    Makes sense – thanks for the help…

    You’ve given me some good ideas ?? – LOL – didn’t think about doing a simple find & replace – the result of too many days with little sleep and too much coffee.

    Thanks for the support from both of you.

    Hi I want to transfer my email contacts on my wordpress site to my constant contact email system.can you advise how i can put my contacts onto an excel sheet.
    Thanks

    Moderator Ipstenu (Mika Epstein)

    (@ipstenu)

    ?????? Advisor and Activist

    jackoleary – That’s a non-topical question.

    Use https://www.joostdevalk.nl/wordpress/users-to-csv/ and next time make your OWN topic for questions like that.

Viewing 8 replies - 1 through 8 (of 8 total)
  • The topic ‘Backup sub site’ is closed to new replies.