AdamBryner Posted April 9, 2007 Share Posted April 9, 2007 Hi Guys! Over this past weekend, I've switch one of my servers to another provider. I'm wondering if there any quick way inside WHMCS to change all customer accounts to the new server... Thanks for any help you can offer. Best Regards, Adam Bryner 0 Quote Link to comment Share on other sites More sharing options...
Adam Posted April 9, 2007 Share Posted April 9, 2007 Hey, If you know PHP/SQL, you can run a few commands in the database. But other then that, you will have to go into each client and change their server to the new server you setup. From, Adam 0 Quote Link to comment Share on other sites More sharing options...
WHMCS CEO Matt Posted April 9, 2007 WHMCS CEO Share Posted April 9, 2007 If you want to change all clients in WHMCS from one server to another then the query to run would be as follows: UPDATE tblhosting SET server='newserveridhere' Matt 0 Quote Link to comment Share on other sites More sharing options...
AdamBryner Posted April 9, 2007 Author Share Posted April 9, 2007 THanks guys, that did the trick. Appreciate it. 0 Quote Link to comment Share on other sites More sharing options...
worsin Posted November 2, 2010 Share Posted November 2, 2010 If you want to change all clients in WHMCS from one server to another then the query to run would be as follows: UPDATE tblhosting SET server='newserveridhere' Matt Where do i find the server id. i tried the IP and it messed everything up. 0 Quote Link to comment Share on other sites More sharing options...
m00 Posted November 2, 2010 Share Posted November 2, 2010 Look up the ID in the tblservers MySQL table. You can also look it up by hovering over the "edit" button after the desired server on the "Servers" page of your WHMCS admin environment. 0 Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.