Transfer Sites Between Clients on PLesk?

[illiquent]

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?

 

[sieb@]

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

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

 

[illiquent]

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.

 

[JackL]

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.