LittleBrother
Feb 15 2006, 12:42 PM
hi, my first howto, easy and usefull, i hope.
to transfer a domain from one client to another in Plesk all it takes is 3 sql querys. Tested on Plesk 7 but i think it should work on other versions too.
open op a shell and be sure to be logged in as root.
$ mysql -uadmin -p
$ [ type the plesk admin password]
$ USE psa;
$ SELECT * FROM clients
[write down id of the client you want to transfer the domain too ]
$ SELECT * FROM domains;
[write down id of domain you want to transfer ]
$ UPDATE domains SET cl_id = [client id] WHERE id = [ domain id ];
$ QUIT
that's all, if you now open Plesk control panel you see the domain is transferred to another client.
Squire
Feb 15 2006, 04:36 PM
umm... Thanks for the How To Littlebrother, but I have to wonder what version of Plesk you're running.
With 7.5.x changing the owner can be done right from the control panel. No muddling around in the psa database required.
If you log into the CP as admin and go to any client you should be able to do the old select a domain via check box and then select Change Owner. This capability hasn't been built into Plesk for long though, so if you have an older version it's not there.
LittleBrother
Feb 16 2006, 02:10 AM
QUOTE
to transfer a domain from one client to another in Plesk all it takes is 3 sql querys. Tested on Plesk 7 but i think it should work on other versions too.
true, it is possible in Plesk7.5
http://download1.swsoft.com/Plesk/Plesk7.5...ml/ch05s01.html
but not in Plesk7 or Plesk7Reloaded.
http://download1.swsoft.com/Plesk/Plesk7.1...in/ch05s01.html
thanks for pointing that out.