How to move clients from old server to new in whmcs

[1337]

Hello,

 

I wanted to move all clients from 2 of my servers to 1. So those 2 full ones you see below, I want to move to the empty one, in WHMCS.

 

 

I already moved all cpanel accounts to the new server, I just need to know how to do it in whmcs. I want to move. So I can suspend / terminate/ ext..

[WHMCS John]

Run the following from the SQL tab of phpmyadmin:

update tblhosting
set server = 'y'
where server = x;

Where y is the ID of the new server and x is the ID of the old server. You can see the IF in your browser's URL bar when editing it.

 

As always, please backup before making any changes to the database.

[othellotech]

or if you're moving *all* the hosting, you can just change the ip address on the server reocord in configuration/servers