Resolution
RESOLUTION:
Make sure that there is no /root/.my.cnf file with MySQL password. Plesk uses environment variable to pass the password to MySQL server, but the .my.cnf file has greater priority and MySQL uses the password from the file. If it does not match, restoration fails.
Also, check that you are able to connect to MySQL from the command line with:
# mysql -uadmin -p`cat /etc/psa/.psa.shadow` psa if you are not, see the article 346.
Keywords: database restore dump fail psabackup psarestore pmm