C:\Users\Administrator>cd %plesk_dir%\Mysql\bin
C:\Program Files (x86)\Parallels\Plesk\MySQL\bin> mysql -uadmin -p -P 8306 psa Enter password: *********
mysql> select id, name from domains where name = 'your-domain.com';
+------+-------------+ | id | name | +------+-------------+ | 1164 | your-domain.com | +------+-------------+ 1 row in set (0.00 sec)
mysql> select id, object_id from Subscriptions where object_id = 1164; +-----+-----------+ | id | object_id | +-----+-----------+ | 861 | 1164 | +-----+-----------+ 1 row in set (0.00 sec)
mysql> select id from ServiceInstances where servicePackageId = '861' AND serviceInstallationId = (select id from ServiceInstallations where name = 'PleskFileSystem'); +-----+ | id | +-----+ | 555 | +-----+ 1 row in set (0.06 sec)
mysql> select * from ServiceInstanceProperties where serviceInstanceId = 555; Empty set (0.00 sec)
mysql> insert into ServiceInstanceProperties (`serviceInstanceId`, `name`, `value`) values (555, 'root', 'C:\\Websites\\your-domain.com'); Query OK, 1 row affected (0.17 sec)
mysql> select * from serviceinstanceproperties where serviceinstanceid = 555; +-------------------+------+-------------------------+ | serviceInstanceId | name | value | +-------------------+------+-------------------------+ | 555 | root | C:\Websites\your-domain.com | +-------------------+------+-------------------------+ 1 row in set (0.00 sec)
|