Two sites on single WordPress and single database

  • Hi all,

    I’ve searched many forums and can’t find the answer. I currently have a website, single wordpress, single database. I’ve enabled multisite and have created a 2nd site using a subdomain. So I now have two sites, single WordPress installation and a single database.

    I need help with the following:

    1) Can I run both of these on a single database (if so, how?) or must I have two databases?

    2) What extra configuration do I need to add to have both sites running on a single database?

    3) What are the pros/cons of a single database or two databases?

    Thanks for any help you can provide!

Viewing 3 replies - 1 through 3 (of 3 total)
  • Moderator Ipstenu (Mika Epstein)

    (@ipstenu)

    ?????? Advisor and Activist

    1) With multisite? Yes.

    2) Read https://codex.www.ads-software.com/Create_A_Network

    3) https://halfelf.org/2011/dont-use-wordpress-multisite/

    Thread Starter Ozzy HB

    (@ozzy-hb)

    Hi Mika,

    Thanks for getting back to me. The “Create a Network” guide was what I followed to get to the stage I’m at, but it doesn’t mention anything about the databases.

    The background to my request is this:

    If I have a website, an online store that for example sells jackets, sweaters, trousers and shoes, I need a 2nd site that is identical but sells only the trousers and shoes, while the first site sells all categories. I’m using WooCommerce and the support guys there said a single installation of WooCommerce cannot filter different products to two different sites, therefore a multisite network with a subdomain site, and a separate installation of WooCommerce was recommended, with two databases. I’m getting confused because if I have two separate database does that not mean I need to duplicate everything on the sites?

    I need as little duplication of work as possible, so the same admin accounts to be able to work on both sites, a single WordPress installation with the same plugins resulting in upgrades of WordPress and the plugins being done only once etc.

    Have I done this correctly so far? I get confused when it comes to the database. I.e if it was two separate WordPress installations I would amend the wp-config.php file on the 2nd site to give a different prefix to the table entries on the same single database. But I haven’t seen anywhere what I need to do for the database entries for two sites running on a single WordPress installation with a single database.

    I hope I’ve made sense here.

    Thanks

    Moderator Ipstenu (Mika Epstein)

    (@ipstenu)

    ?????? Advisor and Activist

    Given that we say Multisite lets you do it with one installation, that would rather presume one database. But anyway, now you know. ONE database for everyone ?? Separate tables per site.

    And that’s the point Woo was making. You would have to duplicate a lot of settings (payments etc) btu there would only be one DB and WP would handle all the tables for you with a Multisite.

Viewing 3 replies - 1 through 3 (of 3 total)
  • The topic ‘Two sites on single WordPress and single database’ is closed to new replies.