Does WordPress MultiSite use separate MySql databases?

WordPress MU uses one database and each blog gets his own tables with the blog id in the prefix, so once you install a network installation your database should have these tables:

  • wp_1_categories
  • wp_1_comments
  • wp_1_link2cat
  • wp_1_links
  • wp_1_options
  • wp_1_post2cat
  • wp_1_postmeta
  • wp_1_posts
  • wp_blogs
  • wp_blog_versions
  • wp_registration_log
  • wp_signups
  • wp_site
  • wp_sitecategories
  • wp_sitemeta
  • wp_usermeta
  • wp_users

And every new site you set up will create separate tables for example:

  • wp_2_categories
  • wp_2_comments
  • wp_2_link2cat
  • wp_2_links
  • wp_2_options
  • wp_2_post2cat
  • wp_2_postmeta
  • wp_2_posts

Related Posts:

  1. Multisite: How to store global options vs. site options?
  2. wp-config dynamic hostname in WP_HOME and WP_SITEURL
  3. DB connection error after copying a WordPress Multisite instance to a second location
  4. Multisite Network Port Num Issues?
  5. Add WordPress MU Network Admin via Database
  6. How to tell which database tables belongs to which multisite site
  7. what are pmxi tables? [closed]
  8. Plugin for editing options on multisite?
  9. How do I transition multiple installations to a single Multisite installation?
  10. find a random blogid across my multisite network that has at least one post published
  11. WP-CLI methods for get_current_blog_id, get_blog_details or $wpdb->prefix
  12. How To Provide Sub-Blogs Their Own Domain Names?
  13. Generate WP-CLI @alias for each site on multisite
  14. How to make WordPress use new Upload Path settings in Multisite Setup
  15. Add site options UI in Multisite Sites > Infos page
  16. What is the correct form action URL for network options pages?
  17. Using WP CLI to set options in WP Multisite
  18. Multiple Domains and Subdomains Using Multisite Installation
  19. Add New Sub Site from the WordPress back end then in sub site options table option_value must be with https
  20. Broken image multisite
  21. Migrating WPMS from apache to IIS7 causes Database Error
  22. Synchronizing Two WordPress Sites Content
  23. Hide root site in Multisite install
  24. How to clone and locally run a network for testing
  25. Two WordPress sites sharing the same database
  26. Subdomain and subdirectories together in one installation
  27. Split a database will improve performance?
  28. How to Move Local Singlesite Database to Remote Multsite Database?
  29. Multisite Subdomain Using More Resources Than Others?
  30. WordPress (+WPMU) Import/Export ALL settings?
  31. Importing Multiple DB to one MU database
  32. Alias domain to Multi-site installation in Apache
  33. Make WordPress Search for Both Main Domain and Subdomain
  34. Bootstrapping WordPress MultiSite Outsite of WordPress – No $wpdb
  35. Multisite setup creating custom table
  36. Multisite Network menu links not updating
  37. How to get option values set from all sites within a Multisite setup?
  38. Bulk theme settings in wordpress multisite
  39. Within the database, where is the flag which says that a user has Super Admin rights?
  40. Bulk activate a theme on multisite
  41. Migrating Multisite – Database error, missing wp_blogs table
  42. WPML tables not deleted when removing multisite subsite, need help clearing up my sql-file! [closed]
  43. What is the function to get options of the parent site of a multisite network?
  44. Database Tables Lost Indexes? How to Recover?
  45. Installed domain-based Multisite but can’t access wp-admin (redirect loop)
  46. Multiple multisite instances connecting to the same database
  47. WordPress Network admin options page: how to store options and where will they be stored?
  48. WordPress Multisite – can I somehow merge the tables?
  49. Create a database for each site created in multisite?
  50. ERR_TOO_MANY_REDIRECTS when i config my subdomains
  51. Will changing the folder name two directories above a fresh wordpress installation break the site?
  52. Register submenu on network menu from the subsite
  53. Least expensive way to get table prefix in multisite installation
  54. 2 website 1 database… Local to online
  55. new multisite, old db
  56. Removing Mutlisite lines stop DB connection
  57. how to migrate wpmu from one host to the other?
  58. Share DB tables between two blogs on the same WP Multisite installation
  59. How can I create blog specific database table in multisite?
  60. Update blog option during create new blog?
  61. How many databases do I need?
  62. Locking one blog of many in a multi user/blog WordPress installation
  63. WordPress Multisites or Multiple WP Single sites?
  64. $wpdb->update prefixes database name to table when executing query
  65. Multisite on single wordpress
  66. WP MultiSite: Can’t select database error after changing to new domain
  67. Combining user database tables while keeping all other data in seperate for multiple sites?
  68. How to make multi site with single Database?
  69. Update WP install to WP network & it broke the DB connection
  70. Sharing users across multiple sites, each on their own database
  71. importing data into wordpress db
  72. How to share User Database between Two Multisite Installations + More
  73. WPMU on MySQL limited to 1GB of space?
  74. How does WP decide how to evaluate database integrity
  75. Problem with new Multisite Installation
  76. get_site_option / update_site_option – the main site and sub sites do not share the same storage
  77. Multisite Equivalent of `register_setting`?
  78. wp option get blogname –url=my-sub-site.com returning main site option
  79. A database for each category?
  80. Problems with WordPress multisite directories/url structures and admin access after migration
  81. allow multisite in the installation process
  82. Error establishing a database connection after moving local wordpressmultisite from one directory to another
  83. Update siteurl and home in multisite subsites to https
  84. wordpress multisite – handle Database
  85. Importing Posts into New Website with Same User ID’s
  86. WordPress automatic Login on other page?
  87. Which action hook to update custom field at network/site-info.php in multisite on update site info
  88. How to reconnect database to existing wordpress multisite setup after changing site name
  89. Multi-site database upgrade claims success, but db_version not updated
  90. multisite shared settings
  91. Get multisite count without php?
  92. Multiple domain with one database
  93. WordPress and SQL – Update and Insert from another table if column value doesn’t exist
  94. Plugin data shared in Multisite
  95. WordPress multisite and one database
  96. 4th Network Site Database Errors?
  97. How to display update message only to admin
  98. Is there a full explanation on how to share a database with two WordPress sites on same server?
  99. HyperDB, Multisite – on new site creation put site’s tables to specific database
  100. Why the sites dropdown in multi-site installation is different from the list of sites when seen full page?
tech