Title: How to split database and data between two servers
Last modified: August 19, 2016

---

# How to split database and data between two servers

 *  Resolved [mikker](https://wordpress.org/support/users/mikker/)
 * (@mikker)
 * [16 years, 4 months ago](https://wordpress.org/support/topic/how-to-split-database-and-data-between-two-servers/)
 * Just thought I’d put this out there as I couldn’t find any info on the intertubes.
   There is plenty of info on how to do it on Drupal but not WordPress. Maybe I’m
   just stupid, but I though someone might need the info also.
 * Problem: We had to split our data and database between two servers and I couldn’t
   figure out how to get the database to connect to the new server. Where did I 
   punch in the IP numbers.
 * Solution: Open WP-config and change DB_HOST from localhost to the IP address 
   of the server where the databases are. So now you know 🙂
 *     ```
       // ** MySQL settings - You can get this info from your web host ** //
   
       /** MySQL hostname */
       define('DB_HOST', 'The IP address of the server where
       the database is located. 192.xxx.xxx.xxx');
       ```
   

The topic ‘How to split database and data between two servers’ is closed to new 
replies.

## Tags

 * [database](https://wordpress.org/support/topic-tag/database/)
 * [hostname](https://wordpress.org/support/topic-tag/hostname/)
 * [IP](https://wordpress.org/support/topic-tag/ip/)
 * [MySQL](https://wordpress.org/support/topic-tag/mysql/)
 * [optimise](https://wordpress.org/support/topic-tag/optimise/)
 * [server](https://wordpress.org/support/topic-tag/server/)
 * [split](https://wordpress.org/support/topic-tag/split/)
 * [wp-config](https://wordpress.org/support/topic-tag/wp-config/)

 * 0 replies
 * 1 participant
 * Last reply from: [mikker](https://wordpress.org/support/users/mikker/)
 * Last activity: [16 years, 4 months ago](https://wordpress.org/support/topic/how-to-split-database-and-data-between-two-servers/)
 * Status: resolved

## Topics

### Topics with no replies

### Non-support topics

### Resolved topics

### Unresolved topics

### All topics