How to configure Snapshots to backup multisite?

I recently tried to use a snaphots backup file to restore a crashed multisite, but it did not restore the user sites. Do I have to set up snapshots for each user site? I didn't think so.

Here's how I configured snapshots:
- Include common files: Themes, Plugins, Media (content-folder/uploads)
- Include all blog database tables in this archive.

Did I miss something?
Thanks, Joe

  • Paul

    @joejacobson,

    Maybe you missed that Snapshot does not backup the entire multisite system. This is by design. Within WordPress multisite each blog/site has its own set of database tables. Normally the primary site has tables prefixed with wp_, Then the next site uses database prefix wp_2_, Then third is wp_3_, etc.

    Normally when you have a broken site you should not need to restore things completely. Normally, if a sub-site is broken you can simple restore that snapshot backup.

  • Opalice

    Hi, i confirm that if you have original wp_ wp_2 ... prefixes the snapshot only backup the wp_ and not the other, here i send you log file.

    Is this planned for "Snapshot" or snapshot is a widget and we delete it for another solution?

    Personally a daily dump sql is for the moment io think the best solution.
    I waiting info or suggestions.

    Thanks

    2013-03-23 20:56:57: Backup: init
    2013-03-23 20:56:57: adding new snapshot: 1364072200
    2013-03-23 20:56:58: table: wp_blog_versions segment: 1/1
    2013-03-23 20:56:59: table: wp_blogs segment: 1/1
    2013-03-23 20:57:00: table: wp_commentmeta segment: 1/1
    2013-03-23 20:57:00: table: wp_comments segment: 1/1
    2013-03-23 20:57:01: table: wp_links segment: 1/1
    2013-03-23 20:57:02: table: wp_options segment: 1/1
    2013-03-23 20:57:03: table: wp_postmeta segment: 1/6
    2013-03-23 20:57:04: table: wp_postmeta segment: 2/6
    2013-03-23 20:57:05: table: wp_postmeta segment: 3/6
    2013-03-23 20:57:06: table: wp_postmeta segment: 4/6
    2013-03-23 20:57:07: table: wp_postmeta segment: 5/6
    2013-03-23 20:57:08: table: wp_postmeta segment: 6/6
    2013-03-23 20:57:08: table: wp_posts segment: 1/3
    2013-03-23 20:57:09: table: wp_posts segment: 2/3
    2013-03-23 20:57:10: table: wp_posts segment: 3/3
    2013-03-23 20:57:11: table: wp_registration_log segment: 1/1
    2013-03-23 20:57:12: table: wp_signups segment: 1/1
    2013-03-23 20:57:13: table: wp_site segment: 1/1
    2013-03-23 20:57:13: table: wp_sitecategories segment: 1/1
    2013-03-23 20:57:14: table: wp_sitemeta segment: 1/1
    2013-03-23 20:57:15: table: wp_term_relationships segment: 1/1
    2013-03-23 20:57:16: table: wp_term_taxonomy segment: 1/1
    2013-03-23 20:57:16: table: wp_terms segment: 1/1
    2013-03-23 20:57:17: table: wp_usermeta segment: 1/11
    2013-03-23 20:57:18: table: wp_usermeta segment: 2/11
    2013-03-23 20:57:19: table: wp_usermeta segment: 3/11
    2013-03-23 20:57:19: table: wp_usermeta segment: 4/11
    2013-03-23 20:57:20: table: wp_usermeta segment: 5/11
    2013-03-23 20:57:21: table: wp_usermeta segment: 6/11
    2013-03-23 20:57:22: table: wp_usermeta segment: 7/11
    2013-03-23 20:57:23: table: wp_usermeta segment: 8/11
    2013-03-23 20:57:24: table: wp_usermeta segment: 9/11
    2013-03-23 20:57:25: table: wp_usermeta segment: 10/11
    2013-03-23 20:57:26: table: wp_usermeta segment: 11/11
    2013-03-23 20:57:26: table: wp_users segment: 1/1
    2013-03-23 20:57:27: table: wp_NAAdsList segment: 1/1
    2013-03-23 20:57:28: table: wp_adrotate segment: 1/1
    2013-03-23 20:57:29: table: wp_adrotate_blocks segment: 1/1
    2013-03-23 20:57:30: table: wp_adrotate_groups segment: 1/1
    2013-03-23 20:57:30: table: wp_adrotate_linkmeta segment: 1/1
    2013-03-23 20:57:31: table: wp_adrotate_schedule segment: 1/1
    2013-03-23 20:57:32: table: wp_adrotate_stats_tracker segment: 1/1
    2013-03-23 20:57:33: table: wp_adrotate_tracker segment: 1/1
    2013-03-23 20:57:33: table: wp_avhfdas_ipcache segment: 1/1
    2013-03-23 20:57:34: table: wp_bannerize segment: 1/1
    2013-03-23 20:57:35: table: wp_comment_archive segment: 1/1
    2013-03-23 20:57:35: table: wp_domain_mapping segment: 1/1
    2013-03-23 20:57:36: table: wp_domain_mapping_logins segment: 1/1
    2013-03-23 20:57:37: table: wp_lockdowns segment: 1/1
    2013-03-23 20:57:38: table: wp_login_fails segment: 1/1
    2013-03-23 20:57:38: table: wp_moderation_reports segment: 1/1
    2013-03-23 20:57:39: table: wp_moderation_warnings segment: 1/1
    2013-03-23 20:57:40: table: wp_network_log segment: 1/1
    2013-03-23 20:57:40: table: wp_network_postmeta segment: 1/1
    2013-03-23 20:57:41: table: wp_network_posts segment: 1/1
    2013-03-23 20:57:42: table: wp_network_rebuildqueue segment: 1/1
    2013-03-23 20:57:43: table: wp_network_term_relationships segment: 1/1
    2013-03-23 20:57:43: table: wp_network_term_taxonomy segment: 1/1
    2013-03-23 20:57:44: table: wp_network_terms segment: 1/1
    2013-03-23 20:57:45: table: wp_option_tree segment: 1/1
    2013-03-23 20:57:46: table: wp_popdom_ab segment: 1/1
    2013-03-23 20:57:46: table: wp_popdom_analytics segment: 1/1
    2013-03-23 20:57:47: table: wp_popdom_campaigns segment: 1/1
    2013-03-23 20:57:48: table: wp_popover segment: 1/1
    2013-03-23 20:57:49: table: wp_post_archive segment: 1/1
    2013-03-23 20:57:50: table: wp_pricing2_entries_wpress segment: 1/1
    2013-03-23 20:57:50: table: wp_pricing2_wpress segment: 1/1
    2013-03-23 20:57:51: table: wp_rg_form segment: 1/1
    2013-03-23 20:57:52: table: wp_rg_form_meta segment: 1/1
    2013-03-23 20:57:53: table: wp_rg_form_view segment: 1/2
    2013-03-23 20:57:53: table: wp_rg_form_view segment: 2/2
    2013-03-23 20:57:54: table: wp_rg_lead segment: 1/1
    2013-03-23 20:57:55: table: wp_rg_lead_detail segment: 1/4
    2013-03-23 20:57:56: table: wp_rg_lead_detail segment: 2/4
    2013-03-23 20:57:56: table: wp_rg_lead_detail segment: 3/4
    2013-03-23 20:57:57: table: wp_rg_lead_detail segment: 4/4
    2013-03-23 20:57:58: table: wp_rg_lead_detail_long segment: 1/1
    2013-03-23 20:57:59: table: wp_rg_lead_meta segment: 1/1
    2013-03-23 20:57:59: table: wp_rg_lead_notes segment: 1/1
    2013-03-23 20:58:00: table: wp_rg_paypal segment: 1/1
    2013-03-23 20:58:01: table: wp_rg_paypal_transaction segment: 1/1
    2013-03-23 20:58:02: table: wp_rli_links segment: 1/1
    2013-03-23 20:58:03: table: wp_shopperpress_orders segment: 1/1
    2013-03-23 20:58:04: table: wp_site_posts segment: 1/1
    2013-03-23 20:58:05: table: wp_site_term_relationships segment: 1/1
    2013-03-23 20:58:06: table: wp_site_terms segment: 1/1
    2013-03-23 20:58:07: table: wp_term_counts segment: 1/1
    2013-03-23 20:58:11: table: wp_translations segment: 1/1
    2013-03-23 20:58:12: table: wp_translations_log segment: 1/1
    2013-03-23 20:58:13: table: wp_useronline segment: 1/1
    2013-03-23 20:58:14: table: wp_wpreport segment: 1/1
    2013-03-23 20:58:14: table: wp_wpreport_archive segment: 1/1
    2013-03-23 20:58:15: table: wp_wpreport_comments segment: 1/1
    2013-03-23 20:58:16: table: wp_wps_bans segment: 1/1
    2013-03-23 20:58:17: table: wp_wps_logins segment: 1/1
    2013-03-23 20:58:18: table: wp_wps_logs segment: 1/1
    2013-03-23 20:58:19: finish: snapshot-1364072200-130323-205640-1155ca8b.zip
    2013-03-23 21:02:28: Sending Archive: snapshot-1364072200-130323-205640-1155ca8b.zip 1005.27kb
    2013-03-23 21:02:28: Destination: ftp: 188.44.78.160
    2013-03-23 21:06:52: Sending Archive: snapshot-1364072200-130323-205640-1155ca8b.zip 1005.27kb
    2013-03-23 21:06:52: Destination: ftp: 188.44.78.160
    2013-03-23 21:14:37: Sending Archive: snapshot-1364072200-130323-205640-1155ca8b.zip 1005.27kb
    2013-03-23 21:14:37: Destination: ftp: 188.44.78.160
    2013-03-23 21:16:57: Sending Archive: snapshot-1364072200-130323-205640-1155ca8b.zip 1005.27kb
    2013-03-23 21:16:57: Destination: ftp: 188.44.78.160

  • joejacobson

    Hi Paul,

    Thanks for your suggestions from 1 month ago. I guess I need to change the database prefixes back to the wp_. I had changed the prefix at the suggestion of a security plugin (WP Better Security). Maybe doing that is okay for a single WP install, but not for multi-sites, apparently.

    I've been avoiding trying to fix my database because I'm not experienced with databases. I asked my Host (Hostgator) if they could help, but they said it was too much for them to do it. I guess I now have to learn how to do it. I found some tutorials online. It doesn't look too hard.

    The security plugin doesn't seem to have a "reverse" button on changing database.

    Do you have any other suggestions on how to change the database back without losing all my primary and subsite databases? I don't want to lose any of my client's subsites.

    Thanks, Joe.

Thank NAME, for their help.

Let NAME know exactly why they deserved these points.

Gift a custom amount of points.