Move Domains From one Client to New Client

[tekmage]

How do I do that without having to recreate everything? Do I use the migration program?

 

[mikk]

look at the commandline tools documentation - you can do that with them

domain.sh -u DOMAIN -clogin NEWCLIENTLOGIN

(or something like that)

 

[modom]

Hi,

The first section works. I am sure the other sections do also but haven't tried them yet...just from some notes I had.

SSH into the server as root and log into the psa database via the mysql client

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

You must end every MySQL command with a ; The line -> is saying that the
command is not a complete command.

Identify the client ID of the client you create in psa.
The client ID is stored in the clients table:

mysql> select * from clients;

The domain ID is stored in the domains table:

mysql> select * from domains;

Once you have the ID's, you need to do the following:

update domains set cl_id = 8 where id = 16;

(I derived the 16 by doing a select on domains and finding the 2cheer4.com domain).

Pooof... the domain is now owned by the new client.



FROM PLESK FAQ'S:

RPM build:

# /usr/bin/mysql -u admin -p`cat /etc/psa/.psa.shadow` -e "SELECT cname, pname, login, id from clients WHERE login = '[psa client login]';" psa

This command retrieves the company name, client name, login and client id, and may be
piped to a file by adding >[filename] after it. After you have retrieved client's id,
execute the following:

RPM build:

# /usr/bin/mysql -u admin -p`cat /etc/psa/.psa.shadow` -e "UPDATE domains SET cl_id = [client id] WHERE name = '[domain name]';" psa

==========================================================

FROM FORUMS:

http://forum.sw-soft.com/showthread.php?s=&threadid=17873

Please use a official Plesk CLI (/usr/local/psa/bin/domain.sh)

It is capable of correct switching domain to different client:

/usr/local/psa/bin/domain.sh -u <domain> -clogin <client_login>