wordpress users - GoFuckYourself.com

crockett · 01-31-2006, 07:49 AM

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?

Juilan · 01-31-2006, 07:51 AM

I think Chio's AutobloggerPro script can do that, I have it but haven't used it for that purpose yet.

Sosa · 01-31-2006, 08:04 AM

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?

Veterans Day · 01-31-2006, 08:08 AM

I think all you need to do is change the front end extension such wp1_blah blah wp2_blahblah

divinity · 01-31-2006, 08:08 AM

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

crockett · 01-31-2006, 08:08 AM

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.

bangman · 01-31-2006, 08:21 AM

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.

seeric · 01-31-2006, 08:23 AM

wordpress has some great forums and help and tutorial sections. i've been in there quite frequently lately.

V_RocKs · 01-31-2006, 08:27 AM

Fortune 500 companies run more with less...

DutchTeenCash · 01-31-2006, 08:46 AM

sure you can

crockett · 01-31-2006, 08:55 AM

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?

bangman · 01-31-2006, 09:12 AM

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.

crockett · 01-31-2006, 09:55 AM

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?

CynthiaB · 01-31-2006, 12:04 PM

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

jayeff · 01-31-2006, 12:30 PM

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...

01-31-2006, 07:49 AM	#1
crockett in a van by the river 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.

01-31-2006, 07:51 AM	#2
Juilan Sultan of Swing 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. __________________ My Best Converting VOD Sponsor \|

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 __________________ Build a Massive Traffic Network, Hands FREE, Totally Automated

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

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

01-31-2006, 08:04 AM	#3
Sosa In Tushy Land 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?

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.

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,422	Fortune 500 companies run more with less...

01-31-2006, 08:46 AM	#10
DutchTeenCash I like Dutch Girls Join Date: Feb 2003 Location: dutchteencash.com Posts: 21,684	sure you can __________________ ICQ 16 91 547 - SKYPE dutchteencash bob AT dutchteencash DOT com ... did you see our newest Sweet Natural Girl Priscilla (18)?

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

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

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...