How to tell which database tables belongs to which multisite site

by

I have a local multisite installation I use for development with a relatively large number of sites set up. Every site has its own numbered database tables (i.e. wp_n_links, wp_n_options, wp_n_postmeta etc.)

Every time I need to look at a database table in phpMyAdmin I have to look through all the wp_n_options tables to find the tables for the site I need and with a lot of sites this can get a bit tedious!

Is there a better way to find out which tables belong to which site?

2 s
2

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

Leave a Comment