How to Create Multiple WordPress Blogs Using a Single Database
Note: See an updated video here: http://educhalk.org/blog/install-wordpress-multi-user-network-wp-3-0/
Related posts:
- WordPress 3.0 Released — Nice Features Tweet WordPress 3.0 was just released and it’s a very...

Very cool. I love the way you focus in with the video to make what you are describing clear. Don.
very cool, thank you so much for the video- it saved me a lot of time.
You’re welcome.
The video is great, and makes it easy to understand how to create more blogs. My questions is how do I create those extra blog pages to be incorporated into my original site. I want multiple blogs on my one site. How is this done?
Just put links on your main blog to your other blogs. If you want the links to appear in a horizontal nav bar, then you would need to add those to your header.php file…otherwise just use the links feature in your main blog.
@figaro
How do you add it to the Header.php file? Is there a video?
@Charmitch1
Not yet, but I’ll make one in the next few days and post it. Seems there are a lot of people wanting to know how to do that.
Great video. Excellent help. Thank you!
You’re welcome Valerie…glad it helped.
Thanks! I have searched forever for this exact information. I would, however, like to know how to incorporate it into my main account page navigation links. Video coming?
I’ll add it to my list…thanks.
This is exactly what I need to do, but it doesn’t work. I suspect this is because we’ve been set up by our content provider with a blog that has the url: blog.mainsite.org, rather than http://www.mainsite.org/blog. So when I follow these directions, the new blog doesn’t show up as blog.mainsite.org/new.
Any suggestions?
@Valerie
Not sure without knowing how your host has the subdomains set-up. You are using subdomains instead of subdirectories. Can you create a new blog off your subdomain like: blog.mainsite.org/newblog
Thank you! This video saved me a lot of work.
I tried to put the new blog folder into the original blog folder (so that in “blog”, of blog.mainsite.org, there is now a folder “new”. this allowed me to install wordpress into blog.mainsite.org/new, but when I tried to then log in, I got error messages about headers. So, obviously that didn’t work.
Thanks, though. Maybe I’ll get it working! I’m learning as I go.
What a genuinely helpful video. Thank you! You answered my questions and I’m very grateful. Am looking forward to checking out the rest of your site!
Hi figaro,
I tried doing this. Copied the wordpress files to a new directory on my ftp and then creating a subdirectory on my file manager. I then changed the config but when I try and put in the new address it says that address could not be displayed. I am relatively new to ftp and I was wondering if you could help me out.
Cheers
@Caleb: If your existing blog is in http://your_site/blog then you should make a copy of blog and name it something different so it looks like http://your_site/blog2. If you do that, then make the changes to the wp-config.php file, then if the first blog was working, the second should work as well.
Hey again Figaro,
Do you have MSN? Because I am having problems setting it up and I could use your help.
Cheers,
Caleb
@Caleb: No, and I’m heading to class in a few and will be offline for the rest of the day. If you want to email me details along with your hosting account login info, I’ll take a look at it tomorrow. Email is 234figaro432@gmail.com
In the screencast you mentioned that you could set up a new database, but don’t have to. What are pros and cons to single versus multi-database?
I plan to build a new WP site for my organization. I also plan the site to be taken over later down the road. Wouldn’t it be best to have a separate database for something like this?
@fretbuzz: I have one site running with a few thousand tables and others with just the 10 default WP tables, so it’s really just up to your own preference.
I decided to just follow the screencast and use the same database. I get the admin name and password generated, but when I try to log in I get looped back to the login. I tried going into the database and changed the username and password there, but it does the same thing… login loops back to login.
Any ideas what I may have did wrong.
@fretbuzz: No, this shouldn’t have anything to do with using the same db for the install.
I have a new website http://www.enhancemyskills.com as well as illyonaire.com. I have a blog for the illyonaire.com now I want to have a blog for the http://www.enhancemyskills.com website. Instead of me using another blogging company how can I just add another blog page to my existing wordpress account? I am not technically savvy. Please help!!!!!!!
Thanks very much, good video.
Question: if I want all my new blog URLs to be different i.e. yarncrafts.com and knitting.com then I would have to have different databases?
If so at what point do I do this? and how?
@pattie: You would need to own the domains and then have separate hosting accounts for each of them or have a hosting account that allowed add-on domains. With add-on domains and them all on the same hosting account, then you could use a single database if you wanted.
First I wanna say this is one of the better tutorials I have seen on word press.Others have been sketchy at best between hard to understand instructors or instructors that sounded like they are half drunk and rambling.
So good job and kudos for a presentation that is effective and easy to sit through.
My question is this,I am trying to design my site,with separate pages,where on each page is a blog about a particular subject.
So I would have my home page, then a page called conversations and on that page categories and posts concerning the page title, “conversations”.Then a page titled the design headache,with the same set up for categories and posts that concern that page and so on and so on with different pages.
So do I have to go through the example shown in this video or is there something I am missing in my options through dash board where I can set up my blog in this fashion?
Any link to a video or tutorial would be greatly appreciated.
@Joseph: Sounds like you want separate blogs for your “pages” so it would be best to set-up separate installs of WP and link them together.
echt gute sache das.
I followed several of your videos and they great. Right to the point.
Duplicating a WP didn’t work for me. So if you can help, great.
The working WP has already been modified to include a few articles and links. I took that one to duplicate it on two other location without success. Do I have to work with a clean install of WP?
Let me explain what I’m trying to do.
I experienced problem with the automatic upgrade of WP. Since I’m new with this tool, I went on the forum and resulted in installing all WP ‘new version’ manually. Not very important since the blog is bright new and does not have much content.
But if this happens in the future, I won’t like it.
So I would like, with one database, to have 2 other blogs, copy of the ‘production’ one, for development and testing.
I ‘just’ have to find the way to duplicate the info from one blog to another, as easily as possible.
Would you have any idea on how best I could reach that goal?
Thanks.
Phil
@Phil: This tutorial doesn’t show how to copy a blog…it shows how to install multiple (different/new) blogs in one database. If you want to duplicate your blog, then you would need to dump your blog tables, do a search/replace to change the wp_ table prefix to something different, then do a search/replace on the url to the new url. Import that changed sql file to the same db…then follow the video from there to set-up a different blog pointing to the new db table prefix.
Hi, the tutorial is great and you helped me out already on wordpress support forum but I want to ask you something: is it possible to install wordpress on a subdomain with the same table as the main blog on original domain because the articles will be the same, but using on the subdomain install a different theme.
Because I tried doing like you show, but when I log into my subdomain it redirects me to the main domain dashboard and if I change the theme it affect both sites.
Am I obliged to use tables and copy all my posts in the subdomain site?
Basically I have http://www.myblog.com and a subdomain http://www.mob.myblog.com which is the mobile version so the contents are the same and I just switch theme.
@m1chel: The problem you run into is the different web address in the database. You may be able to get around it by hardcoding the web address of the subdomain install into the wp-config.php file so that it overrides what’s in the db…I haven’t tried it…just thinking off the top of my head.
Hi. Thank you so much for this tutorial, and all of your tutorials in fact. You are a godsend. One question. As you can see my blog is my domain. I did not set it up as a domain name/blog. I am wondering how I make this work without the /blog added. Do I just copy all of the .com files into a new folder that whose url is .com/photo (for example’s sake) and then add additional when needed or wanted.
Or would it be better to add the /blog to the end of my domain address move the wordpress portion of the domain into it and then duplicate it?
I hope I am making myself clear. I appreciate any direction you could give me. Thank you!
@robyn: You don’t need to move your existing site. You can leave it in root and create your additional blogs in subdirectories names whatever you want.
So if I’m understanding you correctly, I just take the domain http://www.whateveritsnamed.com and add a /blog2 to it and copy the WP files into it? and again and again, if desired?
@robyn: Yes…just follow the directions in the video.
Excellent tutorial. This makes it really easy to create mini-portfolio sites, each with their own theme. Thanks again.
Hi, your tutorial explains things very well, but I’m having a problem. I hope this isn’t a stupid question.
When I do the last step and type in the address for the blog, instead of getting the wordpress page where I can fill in the name of the blog and email, I get an error:
Fatal error: Call to undefined function wp() in /home5/xxxxxx/public_html/test/wp-blog-header.php on line 14
(the xxxx is just a part I took out because I didn’t want to show my information)
Can you help?
Oh, gee I guess it was a stupid question. I figured it out. I am also working with a new theme and did not have the new theme uploaded to the new folder I created for the second blog. Once I did that your instructions worked perfectly.
Awesome video, thank you so much!
Thank you for your extremely helpful tutorial! I have successfully uploaded three blogs using my one database as you instructed. However, while I can easily upload photos as media on my main page to (…/wordpress/wp-content/uploads), I receive the following error when uploading to the folders that I created as copies.
Unable to create directory …/myotherblogpage/wp-content/uploads. Is its parent directory writable by the server?
This first error came about because it apparently could not create the uploads photo automatically like it did for the main site. I manually created the uploads folder and then now receive the following error.
The uploaded file could not be moved to …/myotherblogpage/wp-content/uploads.
Per your video instruction, I did make the initial change to the wp-config file to change the name of the table. That apparently worked fine because I am successfully able to create blog posts on all of my blogs. I just can’t upload media.
Is there another modification I need to make in a file somewhere?
Thank you,
sarah
@sarah
You need to set the proper permissions on the wp-content directory in the new installs. Try 755 and if that doesn’t work, then try 777. You should do this on wp-content and all subdirectories within wp-content.
Is it safe to open up the permissions?
@sarah: I don’t like 777 permissions, but depending on your server environment you may no other option if 755 doesn’t work.
very nice tutorial! Very helpful!
Hi there. I love your tutorials. Very simple and straightforward.
What I’m wondering is if there is a way to allow multiple blogs to share the same theme. Otherwise, I have to copy over the theme to all of the blogs each time I make a change, right?
At the least, I’d like to find a way for them to share the same header. Is this possible?
Thanks!
@Beth Terry
If you want to share themes then give wordpressmu a try. You could share headers, but it would take a bit of code hacking.
Amazing blog Nice work!
I have used your guide before and it has worked wonderfully, however, this time I am having problems. First, when I open the new blog page for the first time, it gives me a “too many redirects” error. I fixed that by using a complete URL to the wp-blog-header file.
That moved me forward to the add title, email and click “install wordpress” button page. The problem here is that everytime I choose the “Install WordPress” button, it loops back to the same exact page.
Anyone have this problem or have ideas on how to fix it?