Unable to access Plesk: Unknown database ‘psa’

bash: fork: retry: Resource temporarily unavailable
November 11, 2020
How to retrieve administrator’s Plesk database password on Plesk 17.8 for Windows and higher?
November 13, 2020

Unable to access Plesk: Unknown database ‘psa’

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.

Comments are closed.

%d bloggers like this: