Support » Networking WordPress » single database, multiple domains

  • I did a lot of research here and on Google, but the only thing I found is that MU might actually not work for this:

    – I have two domains (site1.com, site2.com) and each has its own WP installation with its own custom theme.

    – I want to use one single database, to which I add content using the wp-admin panel. User comments are deactivated; the db only holds my posts.

    – I have configured WP through the admin panel to use site1.com as the wp site location and blog location. The content shows correctly on site1.com

    – On site2.com, however, I get a database connection error. Wp-config.php on site2.com holds the same connection strings as wp-config.php on site1.com as I want to use the same db.

    What am I doing wrong? Do I need to add site2.com in wp-admin panel as a second valid blog location? If so, how do I do that?

    TIA,
    John

Viewing 15 replies - 1 through 15 (of 23 total)
  • You can easily run numerous WP-installations in one database. The only thing you need to be aware of is that each wp-installation needs a unique prefix set in wp-config.php, i.e. wp1_, wp2_ or anything you like.

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

    (@andrea_r)

    Customer Care at Copyblogger Media and Studiopress

    Do I need to add site2.com in wp-admin panel as a second valid blog location? If so, how do I do that?

    Yes, if you;re using the network. It won;t “find” exisiting separate installs on the same server, that’s not how it works.

    Also, in case you’re looking to do this – you will still need to visit the backend of each one to post to each blog. They are siloed content.

    @ maierma: thanks, but this does not work. I changed “wp_” to “wp2_” in wp-config.php on site2.com, and I am getting the same database connection error.

    are you sure this is the only change to be made on site2.com?

    @ andrea_r: how do I add site2.com in the wp-admin panel? I only see one input field for “blog location”.

    Also, what do you mean by “you need to visit the backend of each one to post to each blog”? There is only one blog. Site2.com simply displays the content entered in the wp-admin panel for the original site1.com.

    Andrea Rennick

    (@andrea_r)

    Customer Care at Copyblogger Media and Studiopress

    Go to Super Admin -> Sites. Add it there, where it says “add a site”.

    thx andrea – so you are saying I need to install WPMU to mirror my blog’s entries on a second site? my research in the wp forums found that wpmu does not work for what i want: simply showing blog entries from site1 also on site2 using a custom site2 theme. please confirm.

    tia

    Andrea Rennick

    (@andrea_r)

    Customer Care at Copyblogger Media and Studiopress

    So you have a second domain with a complete separate installation of WP?

    I have a second website on which i want to simply display all posts from blog#1 which is hosted on website#1.

    Do I need a completely new installation of WP on website#2 ?

    Andrea Rennick

    (@andrea_r)

    Customer Care at Copyblogger Media and Studiopress

    Well, no. you’re posting in the multisite section which deals with the new multisite feature which lets you have more than one site (blog) in one install. complete with multiple domains.

    Folks, I hope to follow this, as it looks like it will be helpful for me with a related situation. Just letting you know others are listening!

    Andrea Rennick

    (@andrea_r)

    Customer Care at Copyblogger Media and Studiopress

    @john – the multisite feature now built in to 3.0 will handle multiple blogs in one database. here’s how to enable it:
    http://codex.wordpress.org/Create_A_Network

    A plugin will handle full domains for each site.
    http://wordpress.org/extend/plugins/wordpress-mu-domain-mapping/

    Andrea_r, if this is off-point for this thread, I’ll move it.

    I’m preparing to migrate to WP 3 and have it host at least eight blogs that now stand alone in separate directories, each with its own domain name. I’m studying and (apprehensively) studying some more. In addition to the welcome to the multisite forum, I’ve read two codex sections regarding installation: (a) /Create_A_Network (b) Migrating_Multiple_Blogs_into_WordPress_3.0_Multisite. (The latter exclusively discusses sub-domains, which ain’t for me.) I’ve also perused entries on wpmututorials.com.

    More about the situation:

    ==> Five installations share a database, and their tables are differentiated within it by the first 2-3 characters (e.g., mno_links, qrs_links, xyz_links).

    ==> Three installations have their own databases (in the same mysql instance).

    ==> Currently the blogs each live in separate subdirectories, once removed from the root directory: /holdingplace/blog1/wp-files, /holdingplace/blog2/wp-files, etc.

    ==> I manage the situation at the command line under BSD unix. I have root for the server.

    ==> I do back up!

    Andrea Rennick

    (@andrea_r)

    Customer Care at Copyblogger Media and Studiopress

    In addition to the welcome to the multisite forum, I’ve read two codex sections regarding installation: (a) /Create_A_Network (b) Migrating_Multiple_Blogs_into_WordPress_3.0_Multisite. (The latter exclusively discusses sub-domains, which ain’t for me.)

    You have to pick a format to start, then you use this plugin to map the full domain name:
    http://wordpress.org/extend/plugins/wordpress-mu-domain-mapping/

    More about the situation:

    ==> Five installations share a database, and their tables are differentiated within it by the first 2-3 characters (e.g., mno_links, qrs_links, xyz_links).

    ==> Three installations have their own databases (in the same mysql instance).

    ==> Currently the blogs each live in separate subdirectories, once removed from the root directory: /holdingplace/blog1/wp-files, /holdingplace/blog2/wp-files, etc.

    those’ll be changing. 😉

    You’ll be needing to do this 5 times:
    http://bavatuesdays.com/importing-a-single-wp-blog-to-a-wpmu-installation/

    Once for each exisiting install.

    So, in short, you’ll be picking one install to be the main (preferably in the root) and the rest will be torn down and rolled within.

Viewing 15 replies - 1 through 15 (of 23 total)
  • The topic ‘single database, multiple domains’ is closed to new replies.