SQL Command to change server ?

[ahmandonk]

Hello,

 

anyone help me to change all domain hosting (if active) from "server1" to "server2" ?

 

what the sql for this case ?

[WHMCS John]

Hi,

This should do the trick:

 

UPDATE tblhosting SET server = 'x' WHERE server = 'y' AND `domainstatus` = 'Active';

Replace x with the ID of the new server, y with ID of the old server (found in tblservers).

 

As always, before making changes to your database, please backup.

[ahmandonk]

Hi,

This should do the trick:

 

UPDATE tblhosting SET server = 'x' WHERE server = 'y' AND `domainstatus` = 'Active';

Replace x with the ID of the new server, y with ID of the old server (found in tblservers).

 

As always, before making changes to your database, please backup.

 

218 rows affected. ( Query took 0.0027 sec )

 

Thanks!!!