How to use multiple database in wordpress?

It is possible but you must manually create a new instance of the wpdb class with right settings for your other database.

Quote from the wpdb Codex page:

The $wpdb object can talk to any number of tables, but only one
database: the WordPress database. In the rare case you need to connect
to another database, you will have to instantiate your own object from
the wpdb class with the appropriate connection details. For extremely
complicated setups with many databases, consider using hyperdb
instead.

Related Posts:

  1. MySQL SELECT increment counter
  2. Exclude Statement in SQL
  3. Custom form that store input in database
  4. Restoring WordPress posts from database only
  5. Can a post ID be 0?
  6. Issue with wp_insert_post and post_content field error Could not update post in the database
  7. wp_posts – guid update
  8. what is the wp_5_posts table in the database?
  9. Migrating data between local and development server
  10. WordPress Database Charset/Collate
  11. What is the database table for pages?
  12. Using Dynamic Data Pulled from a MySQL Table in a WordPress Page
  13. Meta query interfering with orderby relevance
  14. Why is Woocommerce writing in my wp_comment table?
  15. save new data to wp_options non-post form
  16. Error establishing a database connection when migrating site to localhost
  17. Strange Deadlock database error for the query “Delete From wp_options”
  18. Strange characters on wordpress site – Not UTF8 Issue
  19. WordPress showing install screen after max_questions error
  20. Connect to live db whilst working locally
  21. PHP variable in WordPress database query
  22. Differences between add_post_meta and update_post_meta
  23. Why do wordpress store pages/posts within the database instead of files? [closed]
  24. Insert custom data to custom table on wordpress database
  25. How does WordPress store data?
  26. Query WordPress database by registered date and role
  27. Tons of Twitter rows in my database
  28. Merging WordPress posts from different databases
  29. How to replace values in WordPress DB using phpMyAdmin
  30. How do I reset a self-hosted WordPress URL?
  31. Select Multiple meta_value from WP DB; Single Query
  32. Is it possible to split database tables using HyperDB?
  33. Show content from database
  34. Customize JSON output
  35. CRUD operations using WordPress database API
  36. How do I get WordPress login to ignore the password input if a particular username is used?
  37. Migrating WordPress from DreamHost to Azure WordPress Resource via UpdraftPlus “wp_options table does not exist…” error
  38. “Error establishing a database” connection on some sites
  39. change wp user status from wp_users table
  40. WordPress is not creating table in database after activating plugin,
  41. Is MariaDB’s Aria storage engine suitable for WordPress?
  42. Difficulty importing my live site to local
  43. How do I delete these post types in my WordPress database?
  44. Slow queries constantly getting stuck on WordPress database of ~100,000 posts
  45. How do I query wp_options for expired transient pairs with MySQL commands?
  46. WordPress returns to an old version
  47. Super slow queries from author archive pages killing my database
  48. WordPress running SQL query to update database from form
  49. How to fix database error duplicate entry
  50. How do I convert a MySQL database from utf8mb4 to utf8 encoding?
  51. WPDB SQL query with prepare() returning variable, not db value
  52. Get value form wordpress database
  53. Moving to another server database connection error [closed]
  54. Why this query is not showing any result on wordpresss home page?
  55. Best practice to limit results in get_row()?
  56. How to migrate a database from a server to another
  57. How to display content from external db with relevant urls
  58. Is there an easy way of exporting posts with their category already asigned and pictures from localhost?
  59. Connect to another WP install and grab post based on custom field
  60. Which table (and column) has the content of configured get_post_meta?
  61. Serialize data before inserting into the DB
  62. how to count click tab menu and insert to database
  63. Adding prefix to WordPress database tables breaks admin capabilities?
  64. What is the best way to resurrect and update my old WordPress site?
  65. content disappearing minutes after it’s published
  66. What is the most efficient way to reset a WordPress site?
  67. Add pdf to a website
  68. Optimizing function that automatically creates internal links based on post title string
  69. Outputting query results
  70. Help With a Large WordPress Based MySQL Database on Shared Hosting
  71. WordPress where clauses in db select
  72. How to display data from db in select list [closed]
  73. Can two domains use the same database?
  74. Native timestamp on wp_options option
  75. _wp_attachment_metadata is not being added to database when PDF files uploaded
  76. SELECT rows between two datetimes when the range is dynamic [closed]
  77. adding user_id and name to a separate table whenever a user register based on role
  78. How do I loop/iterate through posts to edit all img tags?
  79. error establishing a database connection 3
  80. User saved through WordPress backend does not show up in database table users
  81. How to edit posts/pages without making the change live?
  82. Correct and secure way to access a custom SQL database in a custom PHP template file
  83. How to optimise this database query?
  84. How to retrieve user data based on role using SQL?
  85. Adding featured for post using database
  86. Does WordPress Support Using Named Pipes on the Windows Operating System?
  87. get_the_terms is not working
  88. Store id from database query in cookie
  89. Split database on large site?
  90. Store the wordpress “featured image” under »wp_posts« Database table
  91. Custom metabox does not store data
  92. Return image urls with specific base string?
  93. What WordPress file is saving new users to database
  94. wordpress database error
  95. How do i get value from wp_postmeta?
  96. Local host to server import problem
  97. Link to handle $_GET request
  98. WordPress sync with phpbb
  99. featured image not showing up with mysql_connect
  100. SQL Query to get post_id from wp_posts and and meta_key(s) from wp_postmeta

Leave a Comment