• 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.

Resolved Mysql 8 database restore fails

Tofandel

New Pleskian
Username:

TITLE

Mysql 8 database restore fails

PRODUCT, VERSION, OPERATING SYSTEM, ARCHITECTURE

Plesk Obsidian
Version 18.0.54 Update #2
Ubuntu 20.04.6 LTS

PROBLEM DESCRIPTION

When trying to restore a single database from a backup in the plesk interface, it fails with the following error

Execution of /usr/bin/mysql --defaults-file=/etc/mysql/my.cnf -u backup_TMu6UaF -h localhost -P 3306 --default-character-set utf8 --abort-source-on-error my_db failed with return code 2. Stdin is source /tmp/pmm-ru-udb-dump-YJm5rf/backup_sqldump_2307240112_2308060112; exit Stderr is mysql: [ERROR] unknown option '--abort-source-on-error'. Last error is Resource temporarily unavailable

STEPS TO REPRODUCE

  1. Install plesk with mysql 8 (replacing the default mariadb installation)
  2. Create a backup of a domain with a database
  3. Restore the database from the backup

ACTUAL RESULT

Restoration fails with the previous error message

EXPECTED RESULT

The restoration to succeed

ANY ADDITIONAL INFORMATION

--abort-source-on-error being a mariadb specific option not available with mysql 8

YOUR EXPECTATIONS FROM PLESK SERVICE TEAM

Confirm bug
 
A product issue has been confirmed and will be fixed in one of the nearest updates. Internal tracking ID is PPPM-14100.
 
Back
Top