• Introducing WebPros Cloud - a fully managed infrastructure platform purpose-built to simplify the deployment of WebPros products !  WebPros Cloud enables you to easily deliver WebPros solutions — without the complexity of managing the infrastructure.
    Join the pilot program today!
  • Support for BIND DNS has been removed from Plesk for Windows due to security and maintenance risks.
    If a Plesk for Windows server is still using BIND, the upgrade to Plesk Obsidian 18.0.70 will be unavailable until the administrator switches the DNS server to Microsoft DNS.

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

fatbluefish

New Pleskian
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.
 
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.
 
Back
Top