Sharing WP MySQL - GoFuckYourself.com

baddog · 10-24-2007, 06:53 PM

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

Can someone confirm this for me?

RawAlex · 10-24-2007, 07:10 PM

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 · 10-24-2007, 07:14 PM

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 · 10-24-2007, 07:46 PM

Quote:

Originally Posted by 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.

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

Code:

// 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 · 10-24-2007, 07:47 PM

thank you, every one

Subway · 10-25-2007, 03:15 PM

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 · 10-25-2007, 04:20 PM

Quote:

Originally Posted by jacked

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

Code:

// 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 · 10-25-2007, 06:21 PM

Quote:

Originally Posted by 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

Wot he said ^^^

Keep it simple and spread the risk.

baddog · 10-25-2007, 06:23 PM

Quote:

Originally Posted by 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

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

10-24-2007, 06:53 PM	#1
baddog So Fucking Banned Industry Role: Join Date: Apr 2001 Location: the beach, SoCal Posts: 107,089	Sharing WP MySQL Pretty sure I read here that you can have multiple WP blogs on one MySQL database. Can someone confirm this for me?

10-24-2007, 07:14 PM	#3
viki Confirmed User Join Date: Jan 2005 Posts: 2,640	You can setup blogs or other scripts on the same DB as long as you put a different table prefix on during the install. __________________ viki [at] realsexcash [dot] com 228 263 454

10-24-2007, 07:10 PM	#2
RawAlex So Fucking Banned Join Date: Oct 2003 Location: In a house. Posts: 9,465	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.

10-24-2007, 07:47 PM	#5
baddog So Fucking Banned Industry Role: Join Date: Apr 2001 Location: the beach, SoCal Posts: 107,089	thank you, every one

10-25-2007, 03:15 PM	#6
Subway Confirmed User Industry Role: Join Date: Apr 2004 Location: Here Posts: 584	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