Restoring a backup through JetBackup fails, and you receive an error resembling the following:
[ERROR] Error while trying to get data from uapi. Error: The name “databasename” does not begin with the required prefix “username_”.
JetBackup uses the cPanel API for backup and restore operations, and in some cases, a warning from the API will prevent JetBackup from being able to complete a restore. This warning occurs when the database JetBackup is trying to restore does not match the naming scheme currently set up in WHM. This may be due to account name changes, changing prefix requirements, or when restoring a database that uses a different version of SQL (MySQL vs. MariaDB).
Temporarily disabling the database prefixes in WHM will allow the databases to be restored:
- Navigate to "WHM / ServerConfiguration / Tweak Settings".
- Under the "SQL" tab, set the option "Require a username prefix on names of new databases and database users" to Off and save.
- Perform the restore once more through JetBackup.
- Navigate back to "WHM / ServerConfiguration / Tweak Settings" and reenable the prefix setting.