using eps.com.sg as example
back up: after step 1 in bin folder, type
mysqldump -P8306 -uadmin -p psa > psabackup11_18_14.sql
will be asked for password.
step 1: log into cmd
2: cd %plesk_dir%\MySQL\bin
goes to my the bin folder
3: mysql -P8306 -uadmin -p
go into mysql admin functions, type in password.
4:type " use psa;"
5: insert into ServiceInstanceProperties (`serviceInstanceId`, `name`, `value`) values (68, 'root', 'E:/vhosts/eps.com.sg');
this should work.
- 5 Users Found This Useful