WordPress Multisite – How to backup only 1 child website database (not everything)?

ID of a site

The data from a site inside a Multisite network are stored in separate tables of the database. Check the ID of the site in your back-end:

Network –> Websites

Now mouse over, hover effect, about a edit link and you find the ID of the site inside the link /wp-admin/network/site-info.php?id=123

Tables

Each table with this ID inside the name is for this site, like wp_123_posts.

Plugin hint

It gives also several plugins there have this as solution for easy to use, like ‘BackWPup’ or similar. The ID of the site is also easier to find with a helping tool. Also, here you should find plugins, like ‘Multiste Enhancements’.

Multisite Only Tables

The following tables are created during the network installation to help manage the network:

  • wp_site
  • wp_sitemeta
  • wp_blogs
  • wp_blog_versions
  • wp_signups
  • wp_registration_log

Updated tables

The wp_users and wp_usermeta tables become global across the subsites in the network

Site specific tables

After the prefix you find the ID if the site inside the table name, like wp_123_posts.

  • wp_commentmeta
  • wp_comments
  • wp_links
  • wp_options
  • wp_postmeta
  • wp_posts
  • wp_terms
  • wp_termmeta
  • wp_term_relationships
  • wp_term_taxonomy

Related Posts:

  1. Allow user to select a theme to install when they signup
  2. What’s the difference between get_site_option and get_blog_option?
  3. Multisite Domain Mapping with SSL
  4. Basic Multisite Question – Managing Content Centrally
  5. WP-Admin not working properly at WordPress multisite with subdirectories
  6. Multisite – Keep users logged in only to their site
  7. Is there an easy way to separate themes on network?
  8. How to use WordPress multisite with mixed HTTP and HTTPS sites?
  9. How do I know if a user has a blog in WordPress Multisite?
  10. Multisite with Different Domains
  11. Weird Issue with load balanced WP 3.0 setup
  12. Removing orphan users in WordPress Multisite
  13. Sharding BLOGUPLOADDIR
  14. NGinx + WordPress Subdomain Multi with core in Subdirectory
  15. How does WordPress connect sites and the wp_users table?
  16. Hook filter to change wp_upload_dir() path in multisite
  17. How does wordpress multisite manage subdomains?
  18. Error 101 after upgrading WordPress
  19. Suppress subdirectory from WordPress Multisite primary URL
  20. Copy posts from one blog to another in multisite environment
  21. SSL for mapped subdomains in multisite (no plugins)
  22. How to add new sites and map a custom domain in WordPress Multisite?
  23. 301 Redirects for posts, category, pages from original domain to sub-domain of multisite
  24. Child Theme CSS Not Overriding Parent Theme In MultiSite Site
  25. Is the W3 Total Cache plugin a good choice for WordPress MultiSite? [closed]
  26. How To Remove Dashboard Menu Items for Multisite Users?
  27. Can wp-cli display all users and their roles across all sites in a multisite instance?
  28. How do I add JavaScript that will execute on all my sites in Multisite?
  29. How to update_site_option for specific site within network?
  30. Staging setup for multisite installation
  31. Wordrpess Subdomains (Multi-Site) without Wildcard
  32. Create a network of sites
  33. Free Google Analytics plugin that works with WordPress in network mode (WPMU)? [closed]
  34. Sitewide category terms
  35. How Access Multiple WordPress sites with a single login
  36. Multisite – sort merged get_posts() queries
  37. Adding an existing subfolder site to a fresh multisite in the root, would it cause a problem?
  38. API for creating blogs on Multisite?
  39. All subdomains redirecting to mainsite/wp-signup.php after multisite install
  40. Htaccess file isn’t redirecting http sub-pages to https––they display 404 error instead, tried many solutions and none work
  41. WordPress Multi-Site on Ubuntu 18.04 LAMP Keeps Re-Directing
  42. How to force change Network site multi language subdirectory base URL?
  43. Create subdomain out of sight the wp multisite
  44. How to log out from wordpress multiple site?
  45. 301’s not working with multisite
  46. How to protect specific uploaded files from being accessed by non-logged-in users in WP-multisite
  47. Cannot use Network Admin (Dashboard) on Multi-site after 301 www redirect
  48. Suspicious mesage appears instead of images
  49. Include Site 1 Posts in Query for Sub Sites
  50. When creating a multisite, the sub-folders option is not available
  51. MU domain mapping subdomain multisite : map a subdomain on another subdomain
  52. How to exclude specified from all list of Multisite
  53. Where are the files that control the multisite user dashboard?
  54. Issue with WORDPRESS MULTISITE
  55. Is There A Plugin to Create WP Multisite Installs programatically
  56. How to fix that new users show up again in subsite of a Multisite?
  57. Sharing /wp-content/ folder between different WordPress Multisite installs?
  58. wordpress multisite domain mapping redirects to original subdomain
  59. Multisite missing tmp folder error while uploading
  60. WordPress Multisite: Set template languages for a domain?
  61. WordPress Multisite Completely FUBAR?
  62. How to use global category code
  63. How to create a blogs category page with Blog-Types Plugin
  64. Is there something I need to know in order to use WordPress on foreign (Swedish) TLDs?
  65. Multiple domain names map to one site of wordpress subdomain multisite
  66. website redirects to homepage for all 404 pages, wp-cron and admin-ajax.php
  67. multisite installed on subdomain now want another subsite on subdirectory
  68. Multisite install with subdomains on a subdomain
  69. WordPress API – sign-up to multiple Multisites from one single form
  70. Enable HTTPS for AWS hosted multisite domain (with AWS purchased SSL) on already created Load Balancer?
  71. Redirect a user roll to a page after login in mutlisite network
  72. Create multiple clones of site with different branding?
  73. There is how to change url domain on some posts?
  74. Working locally with remote DB not working with multisite
  75. How to make the Broadcast plugin distribute images to several sites?
  76. Load media from another URL on a multisite install
  77. WordPress multisite redirect on digital ocean
  78. wp multisite domain don’t work
  79. Change Default site on wordpress multisite
  80. WordPress Multisite with thousands of blog
  81. Delete all blogs on multisite
  82. Determine if a Network has any sites created already
  83. Multsite Child site Auto Content
  84. Multiple devices wordpress website
  85. Built-in Sitemap on Multi-site install produces 404?
  86. Cannot access network admin panel on multi site
  87. WordPress Multisite giving users access to specific Admin Pages
  88. Setting up WordPress MU off of a subdomain
  89. Disable Please visit the Update Network page to update all your sites. Notice from Dashboard
  90. Multiple WordPress on Virtual Host
  91. Redirect extra url to Multisite in folder
  92. iis6 multisite and permissions
  93. Activate blog hook
  94. Unable to login to admin dashboard after setting up multisite
  95. Not an admin on a multisite setup but I want to change the fonts
  96. Best way to convert two single WordPress sites into Multisite network with shared user base
  97. Some questions about WPMU [closed]
  98. List all blogs a user can admin [duplicate]
  99. WPMU and Chrimes Family Link app
  100. WordPress MU: Cookie error when trying to login on network WP instance
Hata!: SQLSTATE[HY000] [1045] Access denied for user 'divattrend_liink'@'localhost' (using password: YES)