How to merge two servers into one

[tkalfaoglu]

I have two servers listed in the Servers settings  - but they both now refer to the same server (same IP)   (one of them was the old server and then the server got replaced)..Now I have customers in both servers..  How do I migrate all the customers to ONE server in bulk, and then remove the empty server?

SQL commands are ok 🙂

Many thanks, -t

 

Edited July 13, 2021 by tkalfaoglu

[WHMCS Alex]

Hi @tkalfaoglu,

You will want to execute this SQL query (after you have taken a backup of the database):

UPDATE tblhosting SET server = 'NEW_SERVER_ID' WHERE server = 'OLD_SERVER_ID';

Where "NEW_SERVER_ID" is the ID of the server you want all clients to be associated with and "OLD_SERVER_ID" is the ID of the server you intend to remove.

You can easily find the ID's by looking at the tblhosting.id value of the database.

Once that query executes and all clients are associated with the one server, you can remove the duplicate server from inside WHMCS.

I hope this helps.

[tkalfaoglu]

wonderful -- thank you. . I found the server ID's from the Servers page of Settings.. clicking on one server properties brings back a page that displays the id=?? in the URL..