Changing accounts to a new server 2017

[ocastaned]

I just merged two of my servers into a single one. Now I need to change the server for around 600 accounts in WHMCS. Any idea how to do it quickly?

[WHMCS ChrisD]

You'd likely need to do a database query to update this i'll move this over to developer help and someone should be able to help you create a query to do this

[markhughes]

Remember to always backup your database before you run destructive queries on it, be prepare to quickly revert back too.

 

In your database in the table tblservers find the old ID and the old ID.

 

Now you can quick switch them over with this query.

 

https://pastebin.com/TbJz71Cx

 

If you are concerned, run it has a transaction (https://dev.mysql.com/doc/refman/5.7/en/commit.html):

 

https://pastebin.com/wDsp0mHp

 

If it is all good run this:

COMMIT;

 

If something goes wrong you can rollback

ROLLBACK

 

 

(sorry for pastebins, cloudflare was blocking me from posting queries...)

 

- - - Updated - - -

 

By 'old id and old id' I mean, 'old id and new id' (I can't edit my post?)

 

I clearly didn't spell check either, sorry. Haha.