Plesk for Linux kb: technical
- Plesk for Linux
Backup failed and the following error is shown in Plesk backup manager:
PLESK_ERROR: Unable to back up database example. Error: SQLSTATE: Syntax error or access violation: 1049 Unknown database 'example'
The database was removed manually from MySQL and the orphaned record left in the Plesk database.
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"
Please sign in to leave a comment.