How to use remote db tables in current config? [duplicate]

I don’t think there is a good reason to actually do this, but you can simply use what’s in your config to point to another host.

Right from the codex page.

define('DB_HOST', 'mysql.example.com:3307');

Related Posts:

  1. Problem migrating to localhost
  2. I have include wp-config, should I add global $wpdb also?
  3. Can’t Install WordPress (local) Failed to open file wp-includes/wp-db.php
  4. Using wpdb to connect to a separate database
  5. WPDB Insert or if exists Update
  6. get_results using wpdb
  7. $wpdb won’t insert NULL into table column
  8. Please explain how WordPress works with MySQL character set and collation at a low level
  9. Get error messages when $wpdb->insert() returns false?
  10. Detecting errors generated by $wpdb->get_results()
  11. Does dbDelta delete columns as well?
  12. wpdb update add current timestamp not working
  13. How to fetch Data in WordPress using MySQLi or $wpdb
  14. Connect to database using wordpress wp-config file
  15. wpdb->insert multiple record at once
  16. WordPress Unit Testing – Cannot Create Tables
  17. How to define composite keys with dbDelta()
  18. Does wpdb add considerable overhead on queries with large result sets?
  19. Why does $wpdb return strings for mysql integer values?
  20. $wpdb->prepare() warning in WordPress 3.5
  21. Inserting data into custom tables
  22. Hook into $wpdb
  23. Display data from a non wordpress database on a page template
  24. How does $wpdb handle COUNT(*)
  25. How might I retrieve a featured post image from an external WP site and display it as a link back?
  26. WordPress database error: [Query was empty] [closed]
  27. Export wordpress table to excel
  28. How to close wpdb connection? [duplicate]
  29. Inserting Post Meta From SQL
  30. Why does dbDelta() not catch MysqlErrors?
  31. Accessing two databases
  32. Connecting to external oracle database
  33. Can’t save ajax value to database
  34. Custom DB_COLLATE (collation) value not working on fresh install?
  35. What causes the “max_user_connections” warning on WordPress frontend?
  36. $wpdb variable throw this error Call to a member function get_results() on a non-object in
  37. Updating all rows of table with $wpdb
  38. Safe way to find last inserted id in a table?
  39. How to execute mulitple statement SQL queries using $wpdb->query?
  40. Is $wpdb->prepare escaping to much? How to use it properly?
  41. Database slowdown after update to 3.4.1
  42. When and why should I use $wpdb different return types?
  43. How wordpress accesses its own database
  44. Remove database entries where post_date > expiration date
  45. Error connecting to DB in /wp-includes/wp-db.php on line 1538 [closed]
  46. Why can’t I swap a DB in a WP install? [closed]
  47. How to query the WordPress database to get posts of a certain custom post type, taxonomy and field?
  48. Get data from database using $WPDB
  49. How to use a different database to list and manage comments in the backend
  50. Getting all the users who have author privilege
  51. Multiple postmeta with same name for one post in wp_postmeta table
  52. WP Database Table to CSV file
  53. Can I have multiple database users within WordPress?
  54. Cannot update custom database table row
  55. wpdb_prepare with multiple or condition
  56. Show last modified date of database
  57. $wpdb->insert is not working
  58. Error establishing a database connection on Installation
  59. Extracting the post_id via the wp_insert_post action (external db query)
  60. WordPress database error – Error in SQL syntax – I can’t identify any error?
  61. Moving WP from local server to live, error establishing a db connection
  62. In what part of the WordPress core does the users table and usermeta table get joined?
  63. Modify Database in Multi-Site wp_usermeta table
  64. Multiple wp_options tables to share content across installs
  65. Advanced SELECT query with condtional statements
  66. $wpdb doesn’t like to store arrays
  67. Select two sums with single get_var statement
  68. Connect to a remote database for wordpress in my own hosting server
  69. WordPress choose wrong database
  70. Redirecting to old domain after migration website
  71. Switching Databases in LocalHost
  72. Create table from array with prepare
  73. Update from 4.5 to 4.6 failing
  74. Localhost to Staging to Development Dynamic WP-CONFIG
  75. Does WordPress $wpdb functions wait when table is locked?
  76. How to share plugin created database tables between two WordPress sites
  77. How Can I Put Meta_Compare in the Database-Query?
  78. WordPress running SQL query to update database from form
  79. $wpdb->insert Giving duplicates
  80. I’m not able to get access to $wpdb [duplicate]
  81. WPDB SQL query with prepare() returning variable, not db value
  82. $wpdb error (Call to a member function insert() on a non-object)
  83. Have working sql query… trying to adjust it to use $wpdb
  84. Is it important to have integers inserted using %d rather than %s?
  85. Problem in using wpdb
  86. $wpdb->query can’t insert data
  87. Custom WordPress Table wpdb
  88. How to fetch records from database WordPress
  89. Best practice to limit results in get_row()?
  90. Best practice to import user base (subscribers) from one website to another?
  91. AJAX wp-mysql running too slow
  92. CreateOrUpdate in WordPress
  93. Clear Terms from Taxonomy for Specific Post IDs?
  94. Is my way to change WordPress server is correct?
  95. Trouble running $wpdb->query() with last_insert_id
  96. How to get a list of WordPress default database tables?
  97. Connecting to a different database
  98. Using $wpdb | checking entered email against existing emails in db
  99. how to encyrpt DB_PASSWORD in wp-config
  100. Query Column of Specific ID from Database Table
File not found.