Ability to clone databases with definers
On the attempt to clone database with DEFINER Plesk failed if there is no the same user on destination database.
Currently, it is required either manually remove definer from database dump or add super priveleges: https://support.plesk.com/hc/en-us/articles/360005033014-Unable-to-import-MySQL-dump-using-Import-Dump-feature-in-Plesk-ERROR-1227-42000-at-line-1421-Access-denied-you-need-at-least-one-of-the-SUPER-privilege-s-for-this-operation
Since Mysql version 5.7.8 it is possible to use the --skip-definer option with mysqldump:
https://dev.mysql.com/doc/refman/5.7/en/mysqlpump.html
The suggestion is to add ability to clone database skipping definers as option in Plesk GUI
Plesk Tech Support
shared this idea
Thank you for your input. We will consider this functionality in upcoming releases if it is popular. Everyone, please continue voting for this feature if you consider it important.
—
IG
-
Wojciech Pacześniak
commented
The ability of setting any other custom mysqldump option would be very helpful.
E.g. there is also no possibility to disable mysqldump default locking behaviour, using options like --single-transaction or --skip-lock-tables...