Transfer domain to new client in plesk
- August 10th, 2009
- By jrod
- Write comment
Like many things that should be easy in plesk, this requires manually updating the plesk database.
Before making changes to the psa database, it is always a good idea to make a backup:
mysqldump –opt -Q psa > psa.sql
First, we need some database normalization information:
mysql> use psa
mysql> SELECT id,pname from clients order by id;
+—-+——————+
| id | pname |
+—-+——————+
| 1 | My Domains |
| 2 | Desmond Willy |
| 4 | Beacon |
| 5 | Ham |
| 6 | Lefty |
| 7 | Simon Cowle |
| 8 | Scottyl |
| 9 | SomeRandom Guy |
+—-+——————+
8 rows in set (0.00 sec)mysql> select id,displayname,cl_id from domains where displayname=’transferme.com’
-> ;
+—–+—————–+——-+
| id | displayname | cl_id |
+—–+—————–+——-+
| 101 | transferme.com | 1 |
+—–+—————–+——-+
1 row in set (0.00 sec)
So we can see that transferme.com is part of the My Domains client, but we want it to be part of the ‘SomeRandom Guy’ client. To do this we simply need to update the cl_id for the domain:
mysql> UPDATE domains SET cl_id=9 WHERE id=101;
mysql> select id,displayname,cl_id from domains where displayname=’transferme.com’;
+—–+—————–+——-+
| id | displayname | cl_id |
+—–+—————–+——-+
| 101 | transferme.com | 9 |
+—–+—————–+——-+
1 row in set (0.00 sec)
Now that is done. One last thing that is important not to forget, you must ensure that the client you are transfering the domain to has the ip that transferme.com is hosted on in its ip pool. If not, plesk will choke on itself.
