Plesk 7 - Moving a domain between clients

Run your mouse over the clients and domains you need to change and note their id numbers.

Proceed with caution

Example: You want to move domain "abc.com" (domains.id=2) from client Harry (client.id=3) to client Mary (client.id=1).

-----------------------------
Login to mysql with:

mysql -u admin -p`cat /etc/psa/.psa.shadow`

Type:

use psa;

Type:

update domains set cl_id='1' where cl_id='3' and name='abc.com' and id='2';

Type:

exit
-----------------------------

Excellent tutorial Gary, been wondering how to do that. :)

thanks so much man that really helped me for the furture

Do you have any idea if this works the same way for Plesk 6? I don't want to run the risk of losing everything from one of the domains I need to move by doing something wrong.

Thanks! :)

Here's a thread covering Plesk 6:

http://forum.plesk.com/showthread.php?s=&threadid=12711&highlight=update+domains+set

Gary

Perfect. Thanks so much... I have been searching a long time for this information! :)

nice info here helped me too

I use 4psa.com's Notifications. There is a tool for doing this without playing with phpmyadmin. I couldn't live without it. I think it's more secure to use too.

thanks! worked great!