In Plesk, dumps of MySQL/MariaDB databases with DEFINERs/TRIGGERs are exported with incorrect syntax of queries that should create DEFINERs/TRIGGERs

Symptoms

• On a Plesk server dumping the database via Domains > example.com > Databases > example_db > Export Dump is performed for a database with DEFINERs/TRIGGERs queries. Plesk exports such a database dump with incorrect syntax:

  • The result in dump:

    CONFIG_TEXT: /* 50003 CREATE*/ /*!50017 DEFINER...

  • The expected syntax:

    CONFIG_TEXT: /* !50003 CREATE*/ /*!50017 DEFINER..

• Importing a dump of a database with correct syntax in the lines with queries that should create DEFINERs/TRIGGERs fails with the error:

  PLESK_ERROR: Unable to import the example_db dump:
  ERROR 1064 (42000) at line 351: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'DEFINER=`test`@`localhost`*/ /*!50003 TRIGGER test...' at line 1
  program 'mysql' finished with non-zero exit code: 1
  Unable to flush stdout: Broken pipe

Cause

Resolution

Workaround

If update is not possible for some reason you may try the following