Uploaded image for project: 'MariaDB Server'
  1. MariaDB Server
  2. MDEV-6335

Difference in TokuDB engine DDL makes sql dumps incompatible.

        Details

        • Type: Bug
        • Status: Closed
        • Priority: Minor
        • Resolution: Duplicate
        • Affects Version/s: 10.0.12
        • Fix Version/s: None
        • Component/s: None
        • Labels:
          None
        • Environment:
          CentOs 6.x, TokuDB 7.1.6, MariaDB 10.0.11

          Description

          Because of the difference in DDL syntax between TokuTek's TokuDB and MariaDB, mysql dumps are incompatible. This is because one uses ROW_FORMAT and the other COMPRESSION.

          This is a pretty awful situation to be in. Essentially, we're stuck with either one or the other because of the huge amount of data we have.

          There should at least be some aliasing or workaround for this.

            Gliffy Diagrams

              Attachments

                Activity

                Hide
                Permalink
                elenst Elena Stepanova added a comment -

                This is a duplicate of MDEV-5571.
                Quoting the comment by Sergei Golubchik from there:

                There isn't much we can do. mysqldump output is perfectly compatible between mariadb-5.5 and mariadb-10.0. It is not compatible with tokutek-patched releases.
                As a workaround, you could edit the dump, replacing "ROW_FORMAT=TOKUDB" with "COMPRESSION=TOKUDB". Or you can simply start MariaDB on the same datadir and generate the dump in MariaDB. Then it'll use correct MariaDB-compatible syntax.

                Show
                elenst Elena Stepanova added a comment - This is a duplicate of MDEV-5571 . Quoting the comment by Sergei Golubchik from there: There isn't much we can do. mysqldump output is perfectly compatible between mariadb-5.5 and mariadb-10.0. It is not compatible with tokutek-patched releases. As a workaround, you could edit the dump, replacing "ROW_FORMAT=TOKUDB" with "COMPRESSION=TOKUDB". Or you can simply start MariaDB on the same datadir and generate the dump in MariaDB. Then it'll use correct MariaDB-compatible syntax.

                  People

                  • Assignee:
                    Unassigned
                    Reporter:
                    azilber Alexey Zilber
                  • Votes:
                    0 Vote for this issue
                    Watchers:
                    2 Start watching this issue

                    Dates

                    • Created:
                      Updated:
                      Resolved: