Resolved Mysql 8 database restore fails

[Tofandel]

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

 

[Peter Debik]

Thank you for reporting this, @Tofandel. I have added your workaround Resolved - Plesk restore database backup fails on Mysql to the case and forwarded all to developers as internal ID PPS-14807.

 

[Peter Debik]

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

 

[Peter Debik]

Resolved in Plesk Obsidian 18.0.54 #4, published August 24th, 2023.