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

Transfer Sites Between Clients on PLesk?

Discussion in 'Plesk for Windows - 8.x and Older' started by illiquent, Nov 30, 2005.

  1. illiquent

    illiquent Guest

    If i set up a site (mysite.com) under a Plesk Client (ubernewb), can I change that domain to be under a different client without resetting up the domain?
  2. sieb@

    sieb@ Guest

    Just go into the PSA DB and change its clientID to the new client.

    As for an easy way in the interface, Not yet.
  3. illiquent

    illiquent Guest

    cool. thank you.

    I guess I'll have to learn about mySQL.

    I've used MS SQL server a bunch.

    what is the easiest way to find the table with the data I need to change. I can write the SQL, I just need to know which tables and where a "query analyzer" type thing is for mySQL, and how to specify the PSA db.

    any links to any of this data is greatly appreciated.
  4. JackL

    JackL Guest

    Follow these steps:

    1. Start ->Run->cmd
    2. cd "%plesk_dir%\mysql\bin"
    3. mysql -uadmin -padmin_password -P8306 psa
    4. Select * from clients where pname regexp "^client_name_to_whom_domain_will_be_given";
    5. Write down id
    6. Update domains set cl_id=in_point_5_written_down_id where name regexp "^transfered_domain";
    cl_id is numeric value, you can use it without quotation

    7.Restart Plesk

    John S.G.