How to set up multiple WordPress blogs on a single MySQL database

By doctorjay8

I recently joined warrior forum which is great for internet marketing. I love it and am learning a huge amount there. People help each other and it’s like a mastermind group. I’m taking a class there for traffic generation and we needed to make some WordPress blogs.

Some people’s hosting company limited the number of MySQL databases allowed per account. I mentioned that I run multiple WordPress blogs on a single database. I do not like to use WPMU as it has some issues with a few themes and plugins I like to use.

Someone asked how I do it step by step. So here is what I wrote:

If you have Cpanel just use fantastic to create your first WordPress blog.
This gives you the first database.
If not download latest WordPress (I think it could be 2.7.1) from wordpress.org
Basically follow the instruction to create you first blog.
Add all the common plugins you want to use with all the blogs and themes widgets.
You do this by downloading the free ones from wordpress.org, unzip them and ftp them
to the wp-content/plugins and wp-content/themes subdirectories.
This is your base system.
Now copy everything in your WordPress directory to any other directory.
It can be an addon domain or a subdomain WP does not care.
Now if you try to go to that domain or subdomain you’ll be redirected to the original domain you put WP in.
Next ftp just the wp-config.php down to your local computer.
Edit it in notepad or other text editor.
just change that one line:
$table_prefix = ‘wp_’; // Only numbers, letters, and underscores please!
if my new site foo.com i typically change it to
$table_prefix = ‘wpfoo_’; // Only numbers, letters, and underscores please!
or
$table_prefix = ‘wpfoocom_’; // Only numbers, letters, and underscores please!
if I have foo.net or foo.xxx and I do not want both to point to the same blog.
If you want to redirect any domains to the same blog keep the $table_prefix the same
I have nnot tried that but it work so your main domain (the original one) maybe bar.com
and you have foo.bar.com and foobar.bar.com and you want the blog at foo.com to be one blog and
foobar.bar.com to be redirected to foo.bar.com first install bar.com
then foo.bar.com and then just copy the contents of foo.bar.com to foobar.bar.com
I have never done that yet but it should work.

Anyway now wehen you go to the addon domain or subdomain it asks for your email
double check it as if you lose your password you need it for password recovery

When you hit enter you get user id of admin and random password.
I immediately record these in a text document and save with the name of the domain/subdomain sonce when you have lots of blogs you’ll need to separate those.
You hit the login and are taken to login page. Use the admin and the password and you are in.

I hope this makes sense.

Good luck,

Since I’m writing this I might as well mention that I had to put up some squidoo lenses and I wrote my first EzineArticles article. I’m waiting for the article to be approved but the lens and some of the new blogs are here:

This is what I wrote in my main blog….

But I have to chnage it a little (spinning in the article changing business)….

I examined various commercial diets for cost and if they made sense from a scientific basis. You can read a couple of my posts in blogs where I compare NutriSystem and LA Weight Loss and NutriSystem and Jenny Craig. Out of all systems I have studied so far NutriSystem wins easily not only because it uses a low glycemic index menu and also it has the lowest overall cost.

I have known about and used the low glycemic index foods for myself for quite a time but as I was doing my research I have had a real low glycemic index menu in the last week and low and behold my weight has gone down by two pounds and I’m near my all time low and I’m beginning to have as thin a waistline as I did forty years ago.

Finally I just wrote a post on another blog about food labels. Go there and read it.

OK so I also used this post to give myself and my squidoo lens some backlinks.

5 Responses to “How to set up multiple WordPress blogs on a single MySQL database”

  1. Mahaneesh chandra Says:

    wow. great posts. by the way from where do you get such nice ideas and contents. I love the way you post.

  2. doctorjay8 Says:

    Mahaneesh they come from work I do on multiple blogs and problems I have at times so when I solve them I share them here and in other blogs I have.

  3. How to run multiple WordPress Blogs on a single MySQL database? « WordPress Secrets Says:

    [...] is another previous version of this post on another one of my blogs. Very soon I’ll make a video of this operation since I suppose a video is worth one thousand [...]

  4. Pattie Says:

    Please do make a video. I’m a visual learner.
    i want to use WP as mini sites. So, of course I will need multilple WP intallations to keep them separate?
    I’m learning from Warrior too.
    Looking forward to your video.

  5. Laura Says:

    I have a domain that I would like to add to $table_prefix but the I think the domain has issues because it looks like this my-web-sitecom. How do I go about it with this domain? A bit stuck, I’ve tried different ways to put the domain but it will not work. Any help would take this headache away of trying to have multiple blogs on my database.
    Thanks

Leave a Reply