Welcome to the GoFuckYourself.com - Adult Webmaster Forum forums.

You are currently viewing our boards as a guest which gives you limited access to view most discussions and access our other features. By joining our free community you will have access to post topics, communicate privately with other members (PM), respond to polls, upload content and access many other special features. Registration is fast, simple and absolutely free so please, join our community today!

If you have any problems with the registration process or your account login, please contact us.

Post New Thread Reply

Register GFY Rules Calendar
Go Back   GoFuckYourself.com - Adult Webmaster Forum > >
Discuss what's fucking going on, and which programs are best and worst. One-time "program" announcements from "established" webmasters are allowed.

 
Thread Tools
Old 01-31-2006, 07:49 AM   #1
crockett
in a van by the river
 
crockett's Avatar
 
Industry Role:
Join Date: May 2003
Posts: 76,806
wordpress users

Can you run multiple blogs off of one mySQL database? If so is there a limit to how many before it's too much on it? (assuming each blog with be small maybe a few 100 to a few 1k hits per day)

I need to run a bunch of small blogs on one server that already has a few sites.. I really don't want to add several more mySQL data bases, so is there anyway to do this?

Also is there some way to easily update a lot of wordpress blogs, so you don't have to log into each one separately?
__________________
In November, you can vote for America's next president or its first dictator.
crockett is offline   Share thread on Digg Share thread on Twitter Share thread on Reddit Share thread on Facebook Reply With Quote
Old 01-31-2006, 07:51 AM   #2
Juilan
Sultan of Swing
 
Juilan's Avatar
 
Join Date: Feb 2004
Location: XXXodus
Posts: 15,141
I think Chio's AutobloggerPro script can do that, I have it but haven't used it for that purpose yet.
Juilan is offline   Share thread on Digg Share thread on Twitter Share thread on Reddit Share thread on Facebook Reply With Quote
Old 01-31-2006, 08:04 AM   #3
Sosa
In Tushy Land
 
Sosa's Avatar
 
Join Date: Oct 2002
Location: Nebraska
Posts: 40,149
ya I'm pretty sure there is a way to do it but I'm not sure exactly. Have you read the wordpress forums at all?
Sosa is offline   Share thread on Digg Share thread on Twitter Share thread on Reddit Share thread on Facebook Reply With Quote
Old 01-31-2006, 08:08 AM   #4
Veterans Day
Confirmed User
 
Join Date: Jul 2003
Location: The Windy City
Posts: 8,403
I think all you need to do is change the front end extension such wp1_blah blah wp2_blahblah
Veterans Day is offline   Share thread on Digg Share thread on Twitter Share thread on Reddit Share thread on Facebook Reply With Quote
Old 01-31-2006, 08:08 AM   #5
divinity
Confirmed User
 
Join Date: Jan 2005
Location: SF, CA
Posts: 1,041
in theory, you should be able to do it. would just need to add a prefix to the wordpress tables in order to distinguish between them.

http://codex.wordpress.org/Installing_Multiple_Blogs

never tried it personally
__________________
ICQ: 308-491-180
divinity is offline   Share thread on Digg Share thread on Twitter Share thread on Reddit Share thread on Facebook Reply With Quote
Old 01-31-2006, 08:08 AM   #6
crockett
in a van by the river
 
crockett's Avatar
 
Industry Role:
Join Date: May 2003
Posts: 76,806
Quote:
Originally Posted by Sosa
ya I'm pretty sure there is a way to do it but I'm not sure exactly. Have you read the wordpress forums at all?
No not yet, I'm just looking for options. I don't need anything fancy just something that gets the job done. So I figured I'd ask and see if I can do it with wordpress. I figured someone here would know if it could be done easily.

I'd love to just use blogger.com and just host the blogs myself with my own domains. It does everything I need for the most part. However I don't want to waste time building up a blog, to have it get deleted.
__________________
In November, you can vote for America's next president or its first dictator.
crockett is offline   Share thread on Digg Share thread on Twitter Share thread on Reddit Share thread on Facebook Reply With Quote
Old 01-31-2006, 08:21 AM   #7
bangman
Confirmed User
 
Join Date: Sep 2004
Location: PA, USA
Posts: 5,283
When you are installing, simply change the table prefixes in wp-config.php to something different every time.
I'm running a tons of blogs off of one mysql database, and it works fine.
__________________
- David Hall
ICQ: 312744199
bangman is offline   Share thread on Digg Share thread on Twitter Share thread on Reddit Share thread on Facebook Reply With Quote
Old 01-31-2006, 08:23 AM   #8
seeric
..........
 
Industry Role:
Join Date: Aug 2004
Location: ..........
Posts: 41,917
wordpress has some great forums and help and tutorial sections. i've been in there quite frequently lately.
seeric is offline   Share thread on Digg Share thread on Twitter Share thread on Reddit Share thread on Facebook Reply With Quote
Old 01-31-2006, 08:27 AM   #9
V_RocKs
Damn Right I Kiss Ass!
 
Industry Role:
Join Date: Dec 2003
Location: Cowtown, USA
Posts: 32,406
Fortune 500 companies run more with less...
V_RocKs is offline   Share thread on Digg Share thread on Twitter Share thread on Reddit Share thread on Facebook Reply With Quote
Old 01-31-2006, 08:46 AM   #10
DutchTeenCash
I like Dutch Girls
 
DutchTeenCash's Avatar
 
Join Date: Feb 2003
Location: dutchteencash.com
Posts: 21,684
sure you can
DutchTeenCash is offline   Share thread on Digg Share thread on Twitter Share thread on Reddit Share thread on Facebook Reply With Quote
Old 01-31-2006, 08:55 AM   #11
crockett
in a van by the river
 
crockett's Avatar
 
Industry Role:
Join Date: May 2003
Posts: 76,806
Quote:
Originally Posted by bangman
When you are installing, simply change the table prefixes in wp-config.php to something different every time.
I'm running a tons of blogs off of one mysql database, and it works fine.
I'm ok with basic installs of scripts and so on.. In the WP instructions I see you have to edit the wp-config.php file.

// ** MySQL settings ** //
define('DB_NAME', 'wordpress'); //
define('DB_USER', 'username'); //
define('DB_PASSWORD', 'password'); //
define('DB_HOST', 'localhost'); //

I get all that, but where exactly am I suposed to edit the table values? Am I supposed to add another line or something? I see this example line from their instructions..

$table_prefix = 'wp_'; //

do I just add extra line that to the wp-config with what ever prefix I want to use?
__________________
In November, you can vote for America's next president or its first dictator.
crockett is offline   Share thread on Digg Share thread on Twitter Share thread on Reddit Share thread on Facebook Reply With Quote
Old 01-31-2006, 09:12 AM   #12
bangman
Confirmed User
 
Join Date: Sep 2004
Location: PA, USA
Posts: 5,283
Just edit this prefix for every install
Code:
$table_prefix = 'wp_'; //
For example, this could be a line from one of my blogs
$table_prefix = 'wp_'; //

And this from another one
$table_prefix = 'wp2_'; //

As long as they are different, it will work fine.
__________________
- David Hall
ICQ: 312744199
bangman is offline   Share thread on Digg Share thread on Twitter Share thread on Reddit Share thread on Facebook Reply With Quote
Old 01-31-2006, 09:55 AM   #13
crockett
in a van by the river
 
crockett's Avatar
 
Industry Role:
Join Date: May 2003
Posts: 76,806
Quote:
Originally Posted by bangman
Just edit this prefix for every install
Code:
$table_prefix = 'wp_'; //
For example, this could be a line from one of my blogs
$table_prefix = 'wp_'; //

And this from another one
$table_prefix = 'wp2_'; //

As long as they are different, it will work fine.
Yea I understand that part of it, but do I just put that line in the config file? or do I put it somewhere else?

for example :

// ** MySQL settings ** //
define('DB_NAME', 'wordpress'); //
define('DB_USER', 'username'); //
define('DB_PASSWORD', 'password'); //
define('DB_HOST', 'localhost'); //
$table_prefix = 'wp2_'; //

would that be correct?
__________________
In November, you can vote for America's next president or its first dictator.
crockett is offline   Share thread on Digg Share thread on Twitter Share thread on Reddit Share thread on Facebook Reply With Quote
Old 01-31-2006, 12:04 PM   #14
CynthiaB
Confirmed User
 
Join Date: Mar 2005
Location: The OC
Posts: 1,274
There's Word Press Multi User which allows you to run multiple blogs off of one install but it has lots of bugs, they're just developing the software. I've been playing with it and it seems like it's worth the effort.

Cyn
CynthiaB is offline   Share thread on Digg Share thread on Twitter Share thread on Reddit Share thread on Facebook Reply With Quote
Old 01-31-2006, 12:30 PM   #15
jayeff
Confirmed User
 
Join Date: May 2001
Posts: 2,944
In version 1.5 wp-config.php you should see these lines:
define('DB_HOST', 'localhost');
$table_prefix = 'wp_';

and in version 2:
define('DB_HOST', 'localhost'); // 99% chance you won't need to change this value

// You can have multiple installations in one database if you give each a unique prefix
$table_prefix = 'wp_'; // Only numbers, letters, and underscores please!

So you shouldn't need to add anything: just change the $table_prefix line...
jayeff is offline   Share thread on Digg Share thread on Twitter Share thread on Reddit Share thread on Facebook Reply With Quote
Post New Thread Reply
Go Back   GoFuckYourself.com - Adult Webmaster Forum > >

Bookmarks



Advertising inquiries - marketing at gfy dot com

Contact Admin - Advertise - GFY Rules - Top

©2000-, AI Media Network Inc



Powered by vBulletin
Copyright © 2000- Jelsoft Enterprises Limited.