Database structure
WordPressMU creates the following tables upon installation:
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
A quick read will show that all table with the prefix wp_1_ will be associated to the blog with id #1. When a second blog is added to the system, those tables will be called wp_2_ , and so on with each blog created. Yes, 8 tables per blog will be added to the database. There has been some debate about whether the blog-specific table should be in one table, but ultimately it still stores the same amount of data.
This is just one reason why MU is not suited for installation on shared servers. Typically, the MySQL connection setting will be lowered. Also, phpMyAdmin (used to access the database on many shared servers) has a difficult time dealing with very large database, specifically when doing backups.
Later, we’ll look at each table and what is stored there.




September 23rd, 2007 at 5:00 pm
Eagerly awaiting your next post.
Eagerly awaiting your next post.
October 18th, 2007 at 1:24 pm
[...] Database structure is one of the key difference between WP and WPMU, and this post offers an overview of the WPMu database structure quite nicely. With a promise of more discussion to come. [...]
[...] Database structure is one of the key difference between WP and WPMU, and this post offers an overview of the WPMu database structure quite nicely. With a promise of more discussion to come. [...]
October 24th, 2007 at 10:38 am
[...] an addendum to this post, there’s a few extra tables in WPMU 1.3, which should officially be released any day [...]
[...] an addendum to this post, there’s a few extra tables in WPMU 1.3, which should officially be released any day [...]
November 28th, 2007 at 9:40 pm
hi i had install plugins next gen gallery but i want the plugins auto active then i install plugins commander, i did active but but some table that the plugin need didnot add auto-ly how ? tq
hi i had install plugins next gen gallery but i want the plugins auto active then i install plugins commander, i did active but but some table that the plugin need didnot add auto-ly how ? tq
March 4th, 2008 at 3:41 pm
[...] WPMu Tutorials site has two posts about the basic structure of the WPMu database. It is a useful overview that explains how the [...]
[...] WPMu Tutorials site has two posts about the basic structure of the WPMu database. It is a useful overview that explains how the [...]
June 30th, 2008 at 2:48 pm
I’ve just found Wordpress MU because it seems it’s not much published by Wordpress guys themselves.
Anyway, since I’m an ASP coder, and I don’t know much about PHP, I thank you for this site wich is very precious to us.
I’ve seen last post is on June, 21 please don’t stop to carry on this blog. It’s awesome idea and I’m confident WPMU will become soon much more popular and so this blog will increase in users very quickly.
Thanks again
I’ve just found Wordpress MU because it seems it’s not much published by Wordpress guys themselves.
Anyway, since I’m an ASP coder, and I don’t know much about PHP, I thank you for this site wich is very precious to us.
I’ve seen last post is on June, 21 please don’t stop to carry on this blog. It’s awesome idea and I’m confident WPMU will become soon much more popular and so this blog will increase in users very quickly.
Thanks again