Skip to content
Snippets Groups Projects
Select Git revision
  • 14649e1df73fa39223a6f5f31dff3836dbdd0dbc
  • main default protected
  • dev protected
  • f-linkahead-rename
  • f-real-id
  • f-filesystem-import
  • f-filesystem-link
  • f-filesystem-directory
  • f-filesystem-core
  • f-filesystem-cleanup
  • f-filesystem-main
  • f-name
  • keep_changes
  • f-permission-checks-2
  • f-mysql8-tests
  • f-retrieve-history
  • t-distinct-parents
  • v8.1.0
  • v8.0.0
  • v7.0.2
  • v7.0.1
  • v7.0.0
  • v6.0.1
  • v6.0.0
  • v5.0.0
  • v4.1.0
  • v4.0.0
  • v3.0
  • v2.0.30
29 results

dump_updates

  • Open with
  • Download source code
  • Download directory
  • Your workspaces

      A workspace is a virtual sandbox environment for your code in GitLab.

      No agents available to create workspaces. Please consult Workspaces documentation for troubleshooting.

    • Code owners
    Assign users and groups as approvers for specific file changes. Learn more.
    Name Last commit Last update
    ..
    test
    2024-10-02.dump_fix_mariadb_10_6.sh
    README.md
    README.md

    SQL dump updates

    Dump

    This directory contains scripts to update database dumps to newer versions of the MariaDB server.

    Background

    In some cases, restoring the database content from existing SQL dumps may not be possible in a straightforward manner. For those cases, this directory contains scripts to help with known issues.

    Examples for problems include:

    • New reserved keywords in MariaDB, that were previously used as identifiers in code.

    Known issues and their fix

    • SQL syntax error near Offset INT UNSIGNED: If a dump was made before MariaDB 10.6 (LinkAhead < 0.15) and with the SQL backend before 7.0.3, there was a pramater named Offset. With MariaDB 10.6 however, OFFSET became a reserved keyword. This can be fixed by running
      2024-10-02.dump_fix_mariadb_10_6.sh < yourdump.sql > yourdump.fixed.sql