Mass move users between server in WHMCS

[cyberneticos]

Hi guys,

 

We ran into this scenario. We merged 2 dedicated servers into one new one at a new DC. The original servers are created in WHMCS and so is the new one.

 

I have like 200 users I need to assign to the new server.

 

Any way to do this non-manually ?

 

(a sql command -replace- could work I suppose. But don't want to screw anything up.

 

Cheers

[joe123]

We ran into this scenario. We merged 2 dedicated servers into one new one at a new DC. The original servers are created in WHMCS and so is the new one.

dont create a new one in whmcs , just rename the one where you have more clients with the new details of the new server

[cyberneticos]

Hi Joe !

 

hehehe,. that's what we did with the first one. But the problem is that there was more than one (merged 2 servers into one)

[ffeingol]

We just did a similar thing. Back up your db and then:

 

UPDATE tblhosting SET server='NEWIDHERE' WHERE server='OLDIDHERE';

 

Frank

[cyberneticos]

Excellent thanks

 

This should be a feature request I suppose.

[ffeingol]

We just opened a support ticket to find out if any other tables needed to be updated. Since I got the answer back I figured I'd share. It would prob. be a nice feature, but I'm not sure how often it would actually get used.

[cyberneticos]

Yeah, probably not used very often. Certainly not a critical feature. This should be good for now.

 

I figured other tables didn't need change, since the only section in all whmcs that uses that id is hosting server selection. But I wanted to ask first just incase

 

Thanks a lot -it worked fine-