2 wordpress site same database

I would look into using HyperDB instead.
This would allow you to pull data from several databases while one is replicated as the “master” database.

http://wordpress.org/plugins/hyperdb/

From the description page of the plugin:

It supports:

  • Read and write servers (replication)
  • Configurable priority for reading and writing
  • Local and remote datacenters
  • Private and public networks
    – Different tables on different databases/hosts
  • Smart post-write master reads
  • Failover for downed host
  • Advanced statistics for profiling

Hope this helps you.

Related Posts:

  1. Redirect to another page using contact form 7? [closed]
  2. Seriously stuck with some custom meta box/plugin stuff
  3. How to get images from EDD post?
  4. Accessing post’s meta data based on user’s click of a post
  5. Easiest way to add dropdown to a page
  6. How to get the element ID from new menu list that added with add_filter()?
  7. Creating a custom post type, adding custom meta fields, preventing all future editability of posts of this type
  8. Delete mobile menu button [closed]
  9. Center and hide overflow of WP toolbar custom links
  10. How to delete all trashed item in one-go
  11. WordPress custom taxonomy not showing
  12. $pages = get_pages(‘child_of=’.$post->ID); Why arguments are concatenated?
  13. “Allowed memory size” problem [closed]
  14. How to create repeater field manually, without plugin (ACF Pro)?
  15. How to get the custom field value using SQL query
  16. How to arrange custom posts in the backend/admin by custom taxonomy
  17. Problem with checked box on wp car manager plugin
  18. WordPress hide post from custom post-type on a single page
  19. Calling an custom field from theme option at the frontend
  20. WordPress User Frontend Editing Custom Fields
  21. public custom posts not showing in my wordpress plugin
  22. How can I use WordPress functions in my stylesheet?
  23. Is it possible to define a template for a custom post type within a plugin independent of the active theme?
  24. Cropping, Re-sizing and Saving images from one folder to another folder in wordpress
  25. Creating search filter through plugin
  26. Displaying Gravity Form data on WordPress page [closed]
  27. How use %like% in sql statement wordpress
  28. How to trigger $_GET request within admin plugin page?
  29. How to ‘clone’ a wp plugin to make small changes
  30. add mediaelement.js plugins into WordPress video player control bar
  31. Preferred way of cacheing a value in php
  32. Edit Yoast SEO breadcrumbs output [closed]
  33. Adding a slider captcha to the comment system
  34. Query all customers/users and check for duplicate information
  35. WordPress function not being called from jQuery method
  36. WordPress WPforms customization
  37. Where these .js file come to source code?
  38. How I can internationalize variables within the function _e () __ (), etc?
  39. Edit Permalink Structure For Custom Post Type or Modify .htaccess?
  40. Hide a Menu Item on Login
  41. Why can’t I call a (member) function from within a foreach?
  42. WordPress Related Plugin – only show when related content
  43. coding a WordPress AJAX Form using PHP to check if User is Logged Out and Show error
  44. Why does this code snippet create a critical error on my site? [closed]
  45. WordPress custom post type image in RSS
  46. Must use Plugin not updating HTML code in head
  47. Show related posts based of current ACF field name in a single page post (a loop within loop)
  48. Custom Template for wordpress cpt plugin
  49. Next Previous Post in wordpress with previous / next link with title?
  50. WordPress Post HTML after Posting
  51. Settings options not showing up on Sub Menu page in WordPress plugin
  52. Cannot Access Console
  53. Plugin error after installation
  54. woocommerce remove coupon link does not work
  55. Use a hook or filter, or overwrite this Gamipress function?
  56. Replace old theme that understand old css (vcex_icon_box css_animation)
  57. How to insert datas in the table on wordpress?
  58. Display posts by alphabetical order
  59. ACF checkbox return format based on page
  60. How to get database connection details without longing to cpanel in WordPress?
  61. The Build menu theme is frozen with the wordpress theme
  62. Does anyone know why my SEO and title become one?
  63. save_post hook partly firing in update post
  64. How to translate wordpress blog to other languages?
  65. How to translate to spanish wordpress hardcoded content/files?
  66. How to get a post views count using ‘WordPress popular posts’ plugin
  67. Get Shortcode output to database for static post_content
  68. Page not found after creating the add new post slider using custom post type
  69. strtotime not working
  70. Prefix WordPress Taxonomy Tags With Hashtag Symbol Like Twitter
  71. How To Toggle User_Meta in frontend in a form using PHP
  72. Change Woo Custom Endpoint Titles from a Plugin
  73. Change custom rewrite rule when permalink is updated/changed
  74. Optimized PHP & WordPress settings for speed/performance?
  75. Speeding up WordPress on a Local Network
  76. How can I store user preferences in WordPress and retreive them later?
  77. How to disable users to view Other pages
  78. Any method to make specific widget for every post and page?
  79. How to add php plugin code in theme
  80. Include images from pages in wp search.php results in default wp search
  81. how change my menu on submenu
  82. Plugin debugging with errors in activation routine
  83. Embed Javascript code to registered users only
  84. Find all strings between an enclosing shortcode
  85. How to set up php,javascript and css to allow for our finished product to be displayed within a page?
  86. W3 Total Cache Can’t Really Detect Things
  87. Insert data in custom table during new post creation
  88. How do I add php to all links automatically?
  89. Vote It Up Plugin – Add ascending numbers to MostVotedAllTime Chart Function
  90. How to fix vanilla comments extra iframe space
  91. Is an Office a custom post type [closed]
  92. Meta Box plugin image_advanced not showing up on frontend
  93. Creating Features List in WordPress Post
  94. How to hide home title on pages and posts?
  95. PHP Creating a formula from mysql db values and db stored math operator
  96. cURL External API request displays content above other content on page
  97. How can I save the selected page in the dropdown after anyone clicks on Save Changes?
  98. Creating a Table Row by Row
  99. Getting 504 Gateway Timeout Error on AWS Server! [closed]
  100. WordPress issue – data is not showing in wp-admin, but when searching through database, all the data is there