How do I find the highest blog_id number?

This is usually the same as the total number of subsites you have in your WordPress multisite network. So you can do one of two things here. Either:

  • Access your WordPress multisite’s database and find the wp_blogs table. (If your database prefix is something other than wp_, substitute your database prefix. You can locate the table easily once you’re in the database by using your browser’s find function for the word “blogs.”)

    Click into that table to view its data, and you should see that the first column is blog_id. You just want to find the highest number in that column;
  • OR:

  • Just put any number that you know is higher than the total number of subsites you’ve ever had. That may make the query very long (and it may therefore take a while to run), but it should do the trick.

Back to FAQs | Home