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
STEPS TO REPRODUCE
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
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
- Install plesk with mysql 8 (replacing the default mariadb installation)
- Create a backup of a domain with a database
- 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