MariaDB Restore Needs Binary Mode for ASCII \0 Error

  • ERROR: ASCII '\0' appeared in the statement, but this is not allowed unless option --binary-mode is enabled and mysql is run in non-interactive mode. Set --binary-mode to 1 if ASCII '\0' is expected. Query: @J�\'.

    If you get this error, it can be a little confusing. But chances are, your SQL file is compressed, like with gzip. Just uncompress it 🙂