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?

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

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?

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

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

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.

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.

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

Fortune 500 companies run more with less...

sure you can

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?

Just edit this prefix for every install
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?

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

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