Connect to the Plesk server via RDP.
Start a command prompt as an Administrator.
Connect to MySQL:
Note: MySQL admin password is required for this operation. In Plesk Onyx 17.8 and later, retrieve the password with the command plesk sbin psadb --get-admin-password
.
“%plesk_dir%\Mysql\bin\mysql.exe” apsc -uadmin -p -P8306
Once connected, create a new database with the name psa
:
mysql> create database psa;
Exit MySQL:
mysql> quit
Switch to the directory with daily dumps:
cd %plesk_dir%Mysql\Backup
List a name of a Plesk dump with the psa
database:
dir psa*
…
Directory of C:\Program Files (x86)\Plesk\MySQL\Backup
you will find db naming latest available backup and dates, like psa-XXXX.sql
Restore the psa
database using the dump file name from the previous step:
Note: MySQL admin password is required for this operation.
“%plesk_dir%”\Mysql\bin\mysql.exe -uadmin -p -P8306 psa < psa-XXXX.sql
Open Plesk in a web-browser.