Sharing WP MySQL

[baddog]

Pretty sure I read here that you can have multiple WP blogs on one MySQL database.

Can someone confirm this for me?

[RawAlex]

I wrote a little routine that I use to pull the newest post from the WP database and use it to show on another site. Yes, in theory, you can access the data and use it in more than one place.

However, because WP puts all the site information and such into the DB, it is hard to get around stuff. You would have to make a nice custom hack to use one database for the site information (which includes all the links, categories, the base URL, etc) and another to get the posts.

That would probably get ugly.

[viki]

You can setup blogs or other scripts on the same DB as long as you put a different table prefix on during the install.

[jacked]

You can setup blogs or other scripts on the same DB as long as you put a different table prefix on during the install.

first time i noticed it in the wp-config the other day

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

// Change this to localize WordPress.  A corresponding MO file for the
// chosen language must be installed to wp-content/languages.
// For example, install de.mo to wp-content/languages and set WPLANG to 'de'
// to enable German language support.
define ('WPLANG', '');

/* That's all, stop editing! Happy blogging. */

this is under the MySQL settings in the config just change the prefix to wp_1 instead of wp_ , and you should be good to go.

[baddog]

thank you, every one

[Subway]

It is possible but is it wise ?

I rather have 100 small mysql databases than 1 large database.

Much better if you want to restore

[ClickBuster]

first time i noticed it in the wp-config the other day

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

// Change this to localize WordPress.  A corresponding MO file for the
// chosen language must be installed to wp-content/languages.
// For example, install de.mo to wp-content/languages and set WPLANG to 'de'
// to enable German language support.
define ('WPLANG', '');

/* That's all, stop editing! Happy blogging. */

this is under the MySQL settings in the config just change the prefix to wp_1 instead of wp_ , and you should be good to go.

Yeah, DON'T DO THAT! That will only change the configuration, but not the actual table names. Table prefix is configure BEFORE the tables are created But yeah, you can put 100s of them in 1 single db and watch it crash

[GreyWolf]

It is possible but is it wise ?

I rather have 100 small mysql databases than 1 large database.

Much better if you want to restore

Wot he said ^^^

Keep it simple and spread the risk.

[baddog]

It is possible but is it wise ?

I rather have 100 small mysql databases than 1 large database.

Much better if you want to restore

well, the person asking only had 3 blogs, but point taken