multiple wordpress installs w/shared user database but separate content databases

WordPress Multisite has been designed to handle this kind of situation. That would be ideal choice as both the sites use the same domain.

Checkout Multisite table overview. For multisite, the following tables are global to all sites meaning there will be only one table which will be shared among all sites.

  • wp_blogs

  • wp_blog_versions

  • wp_registration_log

  • wp_signups

  • wp_site

  • wp_sitecategories

  • wp_sitemeta

  • wp_users

  • wp_usermeta

Site Specific Tables

When a new additional site is created, the site-specific tables, similar to the stand-alone tables above, are created. Each set of tables for a site are created with the site ID (blog_id) as part of the table name. These are the tables that would be created for site ID 2 and table_prefix wp_:

  • wp_2_commentmeta

  • wp_2_comments

  • wp_2_links

  • wp_2_options

  • wp_2_postmeta

  • wp_2_posts

  • wp_2_terms

  • wp_2_term_relationships

  • wp_2_term_taxonomy

From the table structure it’s apparent that content will be separate for all sites under multisite. They only share common registration, user information etc.

Related Posts:

  1. What is this JavaScript “require”?
  2. How to resolve ORA-011033: ORACLE initialization or shutdown in progress
  3. Oracle SQL query for Date format
  4. Failed to connect to mysql at 127.0.0.1:3306 with user root access denied for user ‘root’@’localhost'(using password:YES)
  5. Can I have multiple primary keys in a single table?
  6. Using wpdb to connect to a separate database
  7. How can I make a WordPress database portable and url independent?
  8. wpdb->insert multiple record at once
  9. Database connection close
  10. How to stop WordPress using utf8mb4_unicode_520_ci collation?
  11. How to create bulk page and content? [closed]
  12. Importing posts from old website to new conflicting post ID’s?
  13. Exporting revisions
  14. WP_Options ID high
  15. Default WordPress settings API data sanitization
  16. Fatal error: Call to undefined function dbDelta()
  17. WordPress for a very large website
  18. How to use multiple database in wordpress?
  19. WP_list_table bulk_action get edit and delete
  20. Is removing orphaned wp_postmeta records safe?
  21. How to intercept update_option() before it saves data?
  22. wpdb query on custom table not working [closed]
  23. What ALL can cause “Another update is currently in progress.”? [closed]
  24. Error connecting to DB in /wp-includes/wp-db.php on line 1538 [closed]
  25. Set Display Name to first and last name (phpmyadmin SQL Query)
  26. How to fix unchanged URLs in Database after running serialized search and replace script?
  27. Trigger Plugin database update after git pull
  28. Does WordPress ever need multiple databases?
  29. Why are no posts showing despite my apparently correct DB restoration?
  30. How to query the WordPress database to get posts of a certain custom post type, taxonomy and field?
  31. Cannot update custom database table row
  32. SQL Error wp_commentmeta – incorrect table definition
  33. WordPress database error – Error in SQL syntax – I can’t identify any error?
  34. Change WordPress prefix for only one table?
  35. Two websites one database, administrator not working on second website
  36. Select two sums with single get_var statement
  37. How to get the SQL of the changes made to the database from an update or upgrade?
  38. Merging two wp_posts tables while avoiding duplicates
  39. How can i add custom fields into the contact form 7 [closed]
  40. Merging two databases without borking it
  41. Make an Items attribute searchable (taxonomy using existing attribute)
  42. How Yoast SEO plugin works with variable %%name%%?
  43. Store partial database to an archive database time to time
  44. Move out of sync posts from one database to another
  45. MS Access to manage WordPress Database
  46. Migration: Copying database content to a different server
  47. Remove empty rows from the database
  48. Custom WordPress Table wpdb
  49. Check if post id exist in table than only update instead of inserting new row
  50. Detail explanation of wordpress database fields and metatag list [closed]
  51. CreateOrUpdate in WordPress
  52. $wpdb->get_results($wpdb->prepare(… You have an error in your SQL syntax;
  53. How to convert srcset links from https to http?
  54. How to get a list of WordPress default database tables?
  55. Can local WordPress installs share /wp-content/ folder and database?
  56. how to encyrpt DB_PASSWORD in wp-config
  57. Choosing http or https during manual installation of WordPress and database
  58. Stringing together content from different databases
  59. Delete all posts that do NOT have a specific tag
  60. Backing up WordPress database and files
  61. Safely store code(html/js..) into database
  62. A change in URL slug in database returns 404, how can I do auto-redirect?
  63. Second ezSQL initialization for MSSQL
  64. Updating seperate database when post attachment is changed
  65. add featured image dialog box disappear
  66. Displaying table data on a page
  67. muliple wordpress installs (network) on different databases
  68. White Screen in Home Page
  69. Continuous SQL query errors from outside source
  70. How to escape percentage sign(%) in sql query with $wpdb->prepare?
  71. Whats the best practise on how to store json data from a custom settings page?
  72. Recovery – Restore Database after moving folder location locally
  73. Migrate Users From laravel to wordpress
  74. WordPress has been updated! Before we send you on your way, we have to update your database to the newest version
  75. /wp-admin not accessible after migrating to local host (no plugin issue)
  76. Job and Employee Performance Tracking with Product Safety
  77. how add more field to wp user and save it to database
  78. set_transient fails if the value has more than 60.000 characters
  79. How do I cleanup my database with data that is no longer being used?
  80. Malware in old website – how to migrate?
  81. Set SQL_BIG_SELECTS and MAX_JOIN_SIZE on a WP_Query
  82. How to optimize wp_option table?
  83. About wp database hooks (error establishing connection)
  84. How to display $wpdb->insert_id; value on redirected page
  85. Database for JQuery Autocomplete field
  86. Should I Use only wpdb Class to Write Custom Queries?
  87. Create Tables in WordPress
  88. Catchable fatal error in formatting.php
  89. Wrong url for the images while using same database for two WordPress installations
  90. WordPress Failed to Login (DB Error)
  91. Sending WordPress database information to cross domain the safe way?
  92. Database Name Change
  93. Weird characters in title if it contain “ ”
  94. Share WordPress Database
  95. Where To Find bb_profile_data(); In bbPress?
  96. ERROR: “Table Prefix” must not be empty
  97. How do you build a database-centric site in WP?
  98. Attach posts based on category and position
  99. Cant Connect to Database
  100. WordPress database connection failed, while mysql client is working [closed]