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:
- Multisite: How to store global options vs. site options?
- wp-config dynamic hostname in WP_HOME and WP_SITEURL
- Unable to change blog language in multisite
- How to add Custom Blog Options to new blog setup form?
- How can I trust switch_to_blog()?
- DB connection error after copying a WordPress Multisite instance to a second location
- Multisite Network Port Num Issues?
- Add WordPress MU Network Admin via Database
- How to tell which database tables belongs to which multisite site
- what are pmxi tables? [closed]
- Plugin for editing options on multisite?
- How do I transition multiple installations to a single Multisite installation?
- WordPress Multisite with multiple domains using Nginx
- Shared table across network
- differences between behavior get_option vs get_site_option in multisite
- find a random blogid across my multisite network that has at least one post published
- WP-CLI methods for get_current_blog_id, get_blog_details or $wpdb->prefix
- How To Provide Sub-Blogs Their Own Domain Names?
- Multisite behind Varnish
- How do I share plugin settings across WordPress network?
- Blog Settings import/export in WordPress Network environment
- Generate WP-CLI @alias for each site on multisite
- Uploading/Deploying a Multi Site Install
- Multisite database upgrade SSL error
- How to make WordPress use new Upload Path settings in Multisite Setup
- Configure WordPress to read from database only, never write
- Add site options UI in Multisite Sites > Infos page
- What is the correct form action URL for network options pages?
- Using WP CLI to set options in WP Multisite
- Multiple Domains and Subdomains Using Multisite Installation
- Add New Sub Site from the WordPress back end then in sub site options table option_value must be with https
- Broken image multisite
- Is it possible to fix/repair all Index, Primary Key, Unique (and all other) structure of a WordPress MS Database
- Migrating WPMS from apache to IIS7 causes Database Error
- Synchronizing Two WordPress Sites Content
- Hide root site in Multisite install
- How to clone and locally run a network for testing
- How to update_site_option for specific site within network?
- Two WordPress sites sharing the same database
- Subdomain and subdirectories together in one installation
- Is it possible to import a wordpress backup from a single site in to a multi-site configuration?
- Split a database will improve performance?
- How to Move Local Singlesite Database to Remote Multsite Database?
- Multisite Subdomain Using More Resources Than Others?
- How to change the database prefix in multisite (WPMU) install
- WordPress (+WPMU) Import/Export ALL settings?
- Importing Multiple DB to one MU database
- Alias domain to Multi-site installation in Apache
- Make WordPress Search for Both Main Domain and Subdomain
- Bootstrapping WordPress MultiSite Outsite of WordPress – No $wpdb
- What are Attributes used for in a WordPress Multisite?
- Multisite setup creating custom table
- Multisite Network menu links not updating
- Is there a way to run upgrade.php for one blog?
- How to get option values set from all sites within a Multisite setup?
- Bulk theme settings in wordpress multisite
- Within the database, where is the flag which says that a user has Super Admin rights?
- Bulk activate a theme on multisite
- Migrating Multisite – Database error, missing wp_blogs table
- How to store custom user data on the database?
- WordPress with Lan and Wan Access?
- WPML tables not deleted when removing multisite subsite, need help clearing up my sql-file! [closed]
- What is the function to get options of the parent site of a multisite network?
- Database Tables Lost Indexes? How to Recover?
- Installed domain-based Multisite but can’t access wp-admin (redirect loop)
- Multiple multisite instances connecting to the same database
- WordPress Network admin options page: how to store options and where will they be stored?
- WordPress Multisite – can I somehow merge the tables?
- Multisite with subfolders- can’t access main site- Error establishing a database connection
- Create a database for each site created in multisite?
- Use WordPress MultiSite (WPMS) with a remote database for each created site
- ERR_TOO_MANY_REDIRECTS when i config my subdomains
- Will changing the folder name two directories above a fresh wordpress installation break the site?
- Register submenu on network menu from the subsite
- WordPress Multisite blogs not working after domain swap
- What are good approaches to routing some urls to a second WordPress install?
- Least expensive way to get table prefix in multisite installation
- Why is MySQL receiving such a large serialized object?
- 2 website 1 database… Local to online
- new multisite, old db
- Removing Mutlisite lines stop DB connection
- how to migrate wpmu from one host to the other?
- Share DB tables between two blogs on the same WP Multisite installation
- How do you update a network option value in the DB via a hook
- How can I create blog specific database table in multisite?
- Update blog option during create new blog?
- How many databases do I need?
- Locking one blog of many in a multi user/blog WordPress installation
- WordPress Multisites or Multiple WP Single sites?
- 403 forbidden when changing settings on WP Multisite non-main sites
- $wpdb->update prefixes database name to table when executing query
- Multisite on single wordpress
- WP MultiSite: Can’t select database error after changing to new domain
- Combining user database tables while keeping all other data in seperate for multiple sites?
- How to make multi site with single Database?
- Update WP install to WP network & it broke the DB connection
- Sharing users across multiple sites, each on their own database
- importing data into wordpress db
- How to share User Database between Two Multisite Installations + More
- How long is “as long as possible” in wp_cache_set()?