Symptoms
Backup failed and the following error is shown in Plesk backup manager:
Unable to back up database example. Error: SQLSTATE[42000]: Syntax error or access violation: 1049 Unknown database 'example'
Cause
The database was removed manually from MySQL and the orphaned record left in the Plesk database.
Resolution
-
Connect to the server via SSH
-
Verify that the database does not exist in MySQL:
# plesk db "show databases like '%example%'"
# (empty output) -
Find the ID of the unexisting database in the PSA database:
# plesk db "select id,name from data_bases where name like '%example%'"
| 529 | example | -
Remove the missing database from Plesk database:
# plesk db "delete from data_bases where id = 529"