How to tell which database tables belongs to which multisite site

The number you refer to is the blog/site ID, so you have multiple methods of finding out which site it is:

  • Look in the sites table, the number should match the ID, providing you with a URL and title
  • Go to example.com/wp-admin/network/site-info.php?id=insert-number-here and you’ll be shown the network admin UI for that site
  • Consider a plugin or custom column in the sites area of the network admin that displays the blog ID

Related Posts:

  1. How can I trust switch_to_blog()?
  2. DB connection error after copying a WordPress Multisite instance to a second location
  3. Add WordPress MU Network Admin via Database
  4. what are pmxi tables? [closed]
  5. Shared table across network
  6. find a random blogid across my multisite network that has at least one post published
  7. WP-CLI methods for get_current_blog_id, get_blog_details or $wpdb->prefix
  8. Multisite: How to store global options vs. site options?
  9. Uploading/Deploying a Multi Site Install
  10. Multisite database upgrade SSL error
  11. Configure WordPress to read from database only, never write
  12. Multiple Domains and Subdomains Using Multisite Installation
  13. Is it possible to fix/repair all Index, Primary Key, Unique (and all other) structure of a WordPress MS Database
  14. Migrating WPMS from apache to IIS7 causes Database Error
  15. Synchronizing Two WordPress Sites Content
  16. How to clone and locally run a network for testing
  17. Two WordPress sites sharing the same database
  18. Is it possible to import a wordpress backup from a single site in to a multi-site configuration?
  19. Split a database will improve performance?
  20. How to Move Local Singlesite Database to Remote Multsite Database?
  21. Multisite Subdomain Using More Resources Than Others?
  22. How to change the database prefix in multisite (WPMU) install
  23. Importing Multiple DB to one MU database
  24. Make WordPress Search for Both Main Domain and Subdomain
  25. Does WordPress MultiSite use separate MySql databases?
  26. Bootstrapping WordPress MultiSite Outsite of WordPress – No $wpdb
  27. Multisite setup creating custom table
  28. Is there a way to run upgrade.php for one blog?
  29. Within the database, where is the flag which says that a user has Super Admin rights?
  30. Bulk activate a theme on multisite
  31. Migrating Multisite – Database error, missing wp_blogs table
  32. How to store custom user data on the database?
  33. WPML tables not deleted when removing multisite subsite, need help clearing up my sql-file! [closed]
  34. Database Tables Lost Indexes? How to Recover?
  35. Installed domain-based Multisite but can’t access wp-admin (redirect loop)
  36. Multiple multisite instances connecting to the same database
  37. WordPress Multisite – can I somehow merge the tables?
  38. Multisite with subfolders- can’t access main site- Error establishing a database connection
  39. Create a database for each site created in multisite?
  40. Use WordPress MultiSite (WPMS) with a remote database for each created site
  41. Will changing the folder name two directories above a fresh wordpress installation break the site?
  42. WordPress Multisite blogs not working after domain swap
  43. Least expensive way to get table prefix in multisite installation
  44. 2 website 1 database… Local to online
  45. new multisite, old db
  46. Removing Mutlisite lines stop DB connection
  47. how to migrate wpmu from one host to the other?
  48. Share DB tables between two blogs on the same WP Multisite installation
  49. How can I create blog specific database table in multisite?
  50. How many databases do I need?
  51. Locking one blog of many in a multi user/blog WordPress installation
  52. WordPress Multisites or Multiple WP Single sites?
  53. $wpdb->update prefixes database name to table when executing query
  54. WP MultiSite: Can’t select database error after changing to new domain
  55. Combining user database tables while keeping all other data in seperate for multiple sites?
  56. How to make multi site with single Database?
  57. Update WP install to WP network & it broke the DB connection
  58. Sharing users across multiple sites, each on their own database
  59. importing data into wordpress db
  60. How to share User Database between Two Multisite Installations + More
  61. How long is “as long as possible” in wp_cache_set()?
  62. WPMU on MySQL limited to 1GB of space?
  63. Questions about MU database schema and how to list all blogs
  64. How does WP decide how to evaluate database integrity
  65. How to use the same users table on multiple wordpress sites
  66. A database for each category?
  67. Problems with WordPress multisite directories/url structures and admin access after migration
  68. allow multisite in the installation process
  69. Error establishing a database connection after moving local wordpressmultisite from one directory to another
  70. Will resetting my database affect other sites on my multisite WordPress install?
  71. WordPress Database Cleanup
  72. Optimal setup for Multi Domain WordPress with Woocommerce
  73. wordpress multisite – handle Database
  74. Importing Posts into New Website with Same User ID’s
  75. WordPress automatic Login on other page?
  76. How to reconnect database to existing wordpress multisite setup after changing site name
  77. Multi-site database upgrade claims success, but db_version not updated
  78. Get multisite count without php?
  79. Multiple domain with one database
  80. Problem in adding new site on WP multisite
  81. WordPress and SQL – Update and Insert from another table if column value doesn’t exist
  82. MySql Database In WordPress Multisite
  83. WP DB Location for “Next Post to Create” Index Value
  84. Error establishing a database connection – Multi-site with subsite don’t exisit [duplicate]
  85. Plugin data shared in Multisite
  86. Merging versions of wp_posts based on post_title
  87. WordPress multisite and one database
  88. WordPress Multisite platform for different city for single db
  89. 4th Network Site Database Errors?
  90. Is there a full explanation on how to share a database with two WordPress sites on same server?
  91. HyperDB, Multisite – on new site creation put site’s tables to specific database
  92. Create unique robots.txt for every site on multisite-installation
  93. Downgrading a WP3.3.1 Network Install
  94. How to disable W3 Total Cache “Performance” menu under multisite? [closed]
  95. wp-config dynamic hostname in WP_HOME and WP_SITEURL
  96. Conditional Image Sizes for Use via Theme Customizer Upload Only
  97. How to check main site user level from subsite in a multisite network
  98. wp option get blogname –url=my-sub-site.com returning main site option
  99. Cannot enable WordPress Network – ‘MULTISITE’ already defined and false
  100. Multisite installation without using domain root

Leave a Comment