MariaDB -> MariaDB import issue: Error at line 1: Unknown command ‘\-’ Fix.

Tony Mucci
Code Kings
Published in
Jun 21, 2024
https://unsplash.com/@slashiophotography

THE PROBLEM

MariaDB released some new code that adds this line at the top of a mariadb-dumps

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

This is causing the break.

THE SOLUTION

You can either remove that line from the SQL dump, or you can run your Mariadb restore command with the — force option

mariadb --user USERNAME_HERE DATABASE_NAME_HERE < FILE_NAME_HERE --force

Happy Coding.

--

--

Tony Mucci
Code Kings

Co-founder of SimpliCourt, dree, My Company Tools, and Eklect Enterprises