Wordpress quiestion! MASS install? Heeeeeeeeeeeeelp - GoFuckYourself.com

Antonio · 02-13-2009, 07:37 AM

here's the story - I have 30 domains on the SAME host, can I install wordpress on all of them but use only ONE database?

What happens right now is I have to add database request for each one of them, then wait for the host to add the databases, then upload to each domain and so on..

I'm 99% sure that this can be done like blog one has tables with prefix 1 eg 1wp_posts, 1wp_comments, then blog 2 has a prefix 2 etc

Anyone done it?

thanks

HomerSimpson · 02-13-2009, 08:43 AM

you can use only one database

in wp-config.php there's a setting for table prefix
$table_prefix = 'wp_'; // Only numbers, letters, and underscores please!

all you need to do is change it
and there you go...

newbreed · 02-13-2009, 08:46 AM

The answer is yes, but it you use one database, you'll be limited to the plugins and template of that ONE database.

Also, you'll need to maintain one Admin section.

Content on each blog would obviously be the same as well.

Bro Media - BANNED FOR LIFE · 02-13-2009, 08:47 AM

Quote:

Originally Posted by newbreed

The answer is yes, but it you use one database, you'll be limited to the plugins and template of that ONE database.

Also, you'll need to maintain one Admin section.

Content on each blog would obviously be the same as well.

Fail.

Quote:

Originally Posted by HomerSimpson

you can use only one database

in wp-config.php there's a setting for table prefix
$table_prefix = 'wp_'; // Only numbers, letters, and underscores please!

all you need to do is change it
and there you go...

Antonio · 02-13-2009, 08:54 AM

Quote:

Originally Posted by HomerSimpson

you can use only one database

in wp-config.php there's a setting for table prefix
$table_prefix = 'wp_'; // Only numbers, letters, and underscores please!

all you need to do is change it
and there you go...

Thanks!

fris · 02-13-2009, 09:01 AM

http://www.optiniche.com/blog/392/mu...ngle-database/

http://sitening.com/blog/how-to-easi...one-code-base/

candyflip · 02-13-2009, 09:24 AM

Quote:

Originally Posted by newbreed

The answer is yes, but it you use one database, you'll be limited to the plugins and template of that ONE database.

Also, you'll need to maintain one Admin section.

Content on each blog would obviously be the same as well.

Sorry man, but you're totally off on this one.

Antonio · 02-13-2009, 09:33 AM

Quote:

Originally Posted by fris

http://www.optiniche.com/blog/392/mu...ngle-database/

http://sitening.com/blog/how-to-easi...one-code-base/

thanks the second link looks like exactly what I need but that code looks a bit weird to me (don't know php)

Code:

// You can have multiple installations in one database if you give each a unique prefix
$domain_list = array();

// auto database name
$domain_list["yourdomain.com"] = ??;

$domain_name = preg_replace(?/^www\./?, ??, $_SERVER["SERVER_NAME"]);

if (array_key_exists($domain_name, $domain_list))
{
$table_prefix = $domain_list[$domain_name];
if (!$table_prefix) { $table_prefix = ?wp_? . md5($domain_name); }
}
else
{
print ?Unknown error?; exit;
}

do I add every domain HERE:
$domain_list = array();

like

$domain_list = array(mydomain.com, mydomain2.com, mydomain3.com);

??

or just use the code as it is

thanks

Bro Media - BANNED FOR LIFE · 02-13-2009, 09:48 AM

Quote:

Originally Posted by Antonio

thanks the second link looks like exactly what I need but that code looks a bit weird to me (don't know php)

Code:

// You can have multiple installations in one database if you give each a unique prefix
$domain_list = array();

// auto database name
$domain_list["yourdomain.com"] = ??;

$domain_name = preg_replace(?/^www\./?, ??, $_SERVER["SERVER_NAME"]);

if (array_key_exists($domain_name, $domain_list))
{
$table_prefix = $domain_list[$domain_name];
if (!$table_prefix) { $table_prefix = ?wp_? . md5($domain_name); }
}
else
{
print ?Unknown error?; exit;
}

do I add every domain HERE:
$domain_list = array();

like

$domain_list = array(mydomain.com, mydomain2.com, mydomain3.com);

??

or just use the code as it is

thanks

yeah

$domain_list = array('domain.com', 'domain2.com', 'domain3.com');

teg0 · 02-13-2009, 10:34 AM

if you use a lot of plugins you could run into some bugs, but someone already pointed that out. If they are pretty basic installs you'll be find as long as you change the prefix.

tranza · 02-13-2009, 11:16 AM

Hope you can fixed your problem

Z · 02-13-2009, 12:15 PM

Wordpress MU...learn it, love it.

02-13-2009, 07:37 AM	#1
Antonio Too lazy to set a custom title Join Date: Oct 2001 Location: Spartaaaaaaaaa Posts: 14,136	Wordpress quiestion! MASS install? Heeeeeeeeeeeeelp here's the story - I have 30 domains on the SAME host, can I install wordpress on all of them but use only ONE database? What happens right now is I have to add database request for each one of them, then wait for the host to add the databases, then upload to each domain and so on.. I'm 99% sure that this can be done like blog one has tables with prefix 1 eg 1wp_posts, 1wp_comments, then blog 2 has a prefix 2 etc Anyone done it? thanks

02-13-2009, 08:43 AM	#2
HomerSimpson Too lazy to set a custom title Industry Role: Join Date: Sep 2005 Location: Springfield Posts: 13,826	you can use only one database in wp-config.php there's a setting for table prefix $table_prefix = 'wp_'; // Only numbers, letters, and underscores please! all you need to do is change it and there you go... __________________ Make a bank with Chaturbate - the best selling webcam program Ads that can't be block with AdBlockers !!! /// Best paying popup program (Bitcoin payouts) !!! PHP, MySql, Smarty, CodeIgniter, Laravel, WordPress, NATS... fixing stuff, server migrations & optimizations... My ICQ: 27429884 \| Email:

02-13-2009, 08:46 AM	#3
newbreed Confirmed User Join Date: Nov 2003 Location: ThatOneProgram.com Posts: 9,898	The answer is yes, but it you use one database, you'll be limited to the plugins and template of that ONE database. Also, you'll need to maintain one Admin section. Content on each blog would obviously be the same as well. __________________ Want to promote SUCCUBUS? Click HERE!!!! \| Want to buy SUCCUBUS? Click HERE!!!! Yeah, yeah, you know, That One Program! \| Want to trade links with StompBunny.com? Loryn ‎(3:16 PM): I love it, just as long as we keep the bedroom door closed from all ears then we can have throw down hard core sex that makes us money haha fuck it we can have sex on money never did that before

02-13-2009, 09:01 AM	#6
fris Too lazy to set a custom title Industry Role: Join Date: Aug 2002 Posts: 55,372	http://www.optiniche.com/blog/392/mu...ngle-database/ http://sitening.com/blog/how-to-easi...one-code-base/ __________________ Since 1999: 69 Adult Industry awards for Best Hosting Company and professional excellence. WP Stuff

02-13-2009, 11:16 AM	#11
tranza ICQ: 197-556-237 Join Date: Jun 2003 Location: BRASIL !!! Posts: 57,559	Hope you can fixed your problem __________________ I'm just a newbie.

02-13-2009, 10:34 AM	#10
teg0 Confirmed User Join Date: Jan 2006 Location: Gringo in Puerto Rico Posts: 4,204	if you use a lot of plugins you could run into some bugs, but someone already pointed that out. If they are pretty basic installs you'll be find as long as you change the prefix.

02-13-2009, 12:15 PM	#12
Z Vidi Vici Veni Industry Role: Join Date: Nov 2002 Posts: 6,308	Wordpress MU...learn it, love it.