Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Add support for different MariaDB dump versions #258

Open
1 task done
strarsis opened this issue Jul 17, 2024 · 2 comments
Open
1 task done

Add support for different MariaDB dump versions #258

strarsis opened this issue Jul 17, 2024 · 2 comments

Comments

@strarsis
Copy link

strarsis commented Jul 17, 2024

Feature Request

Describe your use case and the problem you are facing
MariaDB introduced broke with backward dump file compatibility, trying to import such a dump in older target versions of MariaDB would therefore result in an error (ERROR at line 1: Unknown command '\-'.).

Describe the solution you'd like
According to the official blog post/announcement there are workarounds that should make the dump again compatible with older versions of MariaDB.

@strarsis
Copy link
Author

Related issue: #254

@chrilleferna
Copy link

The change introduced by mariadb mid-May was to add the following line at the top of the sql dump file:

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

When trying to import such a file this results in the described fatal error.

The simplest(?) and most robust(?) workaround would be to test if the dumpfile contains this line and if so remove it before the import (tail +2).

Would be VERY nice if you could fix this

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Projects
None yet
Development

No branches or pull requests

3 participants