1. Please take a little time for this simple survey! Thank you for participating!
    Dismiss Notice
  2. Dear Pleskians, please read this carefully! New attachments and other rules Thank you!
    Dismiss Notice
  3. Dear Pleskians, I really hope that you will share your opinion in this Special topic for chatter about Plesk in the Clouds. Thank you!
    Dismiss Notice

Move Domains From one Client to New Client

Discussion in 'Plesk for Linux - 8.x and Older' started by tekmage, Apr 10, 2005.

  1. tekmage

    tekmage Guest

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

    mikk Basic Pleskian

    Jan 29, 2005
    Likes Received:
    look at the commandline tools documentation - you can do that with them

    domain.sh -u DOMAIN -clogin NEWCLIENTLOGIN

    (or something like that)
  3. modom

    modom Guest


    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.


    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




    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>