• Introducing WebPros Cloud - a fully managed infrastructure platform purpose-built to simplify the deployment of WebPros products !  WebPros Cloud enables you to easily deliver WebPros solutions — without the complexity of managing the infrastructure.
    Join the pilot program today!
  • Support for BIND DNS has been removed from Plesk for Windows due to security and maintenance risks.
    If a Plesk for Windows server is still using BIND, the upgrade to Plesk Obsidian 18.0.70 will be unavailable until the administrator switches the DNS server to Microsoft DNS.

[#PPPM-3628] 12.5.30 - Database Restore - Views failed

Elompenta

Regular Pleskian
If i restore a database, views failed with the following error and the "views" in the Database missing after restore. All other content are restored correct

Code:
Warning: Restore domain "audi.de"
Failed deployment of database de_test (domain audi.de)
Warning: 
Errors occurred during deployment of database content. Not all content may be restored. Resolve the errors if required or try to restore the content manually from the archive: databases/bmw_de_test_1[sqldump]: backup_1511131429.tgz
Warning: 
Execution of /usr/bin/mysql --no-defaults -u backup_1CqY30r -h localhost -P 3306 --default-character-set utf8 bmw_de_test failed with return code 1. Stdin is source /tmp/migration-unpack-WAyyS7/backup_1511131429; exit Stderr is ERROR 1227 (42000) at line 75 in file: '/tmp/migration-unpack-WAyyS7/backup_1511131429': Access denied; you need (at least one of) the SUPER privilege(s) for this operation
 
Bug ID: #PPPM-3628
As a workaround you can switch the button "Home -> Tools & Settings -> Database Servers -> Database Hosting Settings -> Allow remote connections from any host"
 
Back
Top