Issue MariaDB failed imports - ERROR at line 1: Unknown command '\-'.

[fatbluefish]

Server operating system version

CentOS 7.9

Plesk version and microupdate number

18.0.60 Update #1

Hi,

We operate a number of plesk servers, some are still running CentOS7/MariaDB 10.2.44 due to not being able to upgade or migrate yet.
Previous attempts to update MariaDB had failed sue to depencies installed via the CityFan repo.

When importing dumps created from newer versions of MariaDB we get the error:

ERROR at line 1: Unknown command '\-'.
[DATETIME] [ERROR 'mysql' finished with non-zero exit code: 1

Unzipping and removing line 1 from the export allows the file to import correctly.

/*!999999\- enable the sandbox mode */

Is there a setting anywhere in Plesk, plesk.ini or MariaDB that we can untilise to ignore this 1st line?

Thanks.

 

[Kaspar@Plesk]

This seems to be caused by a bug in MariaDB and happens when different versions of the mysqldump utility are used for exporting and importing.

There is no option to disable the line for dumps made with Plesk. This issue should get resolved when the MariaDB bug gets fixed.

 

[Mark_NLD]

Duplicate with Question - Migration from plesk to plesk db error