If you get a database error when attempting to restore from backup using 1-click web apps (Installatron), you'll need to manually restore the database backup file. This occurs when the database contains unrecognized characters or errors in the scheme.
You'll find the archive for this backup using the Plesk File Manager (or SFTP/FTPS) by navigating to the "application_backups" folder.
By downloading and extracting that backup, you'll find the APP-DATA.sql file which contains the complete database. Often you can then use Plesk's DB import option to import that database file. Sometimes it'll import just fine like that, but at least if it fails there too, it'll give you a more clear error as to why it failed, which is often correctable.
Here's how to use Plesk to import the database:
- Log in to Plesk
- Choose Databases, then under the database that you're restoring from backup (make sure you select the right one!) choose Import Dump.
- Under the upload section at the top choose the option to select a file and select the APP-DATA.sql file