How to restore one of the databases from a domain backup without restoring all of the databases?
- Download the domain backup file (.tar) from the Parallels Plesk Panel (PP) web interface
- Unpack it to a folder
- Browse the contents and go to the Databases folder
- Find a folder with the needed database name
- Go inside and unpack the .tgz and then .tar archives. You will get the .sql file of your database.
On your PP server run this command to restore the database:
# MYSQL_PWD=`cat /etc/psa/.psa.shadow` mysql -u admin < PATH_TO_THE_SQL_FILE