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

mysqldump --no-data does not show auto increment counter for unused tables

    XMLWordPrintable

Details

    • Bug
    • Status: Open (View Workflow)
    • Trivial
    • Resolution: Unresolved
    • 10.3.37
    • None
    • Scripts & Clients
    • None

    Description

      Hi,

      I assume that this is for other versions as well, but I experienced this on 10.3.37.

      When running mysqldump --no-data to dump the schema, some tables do not show their auto increment value. I initially thought this was due to the table not being opened, but it is not. I tried to login to the same instances and execute SHOW CREATE TABLE, but afterwards the dump still did not show the value.

      I don't know the cause or how to reproduce, but adding this issue anyways as it might be useful later on.

      Thank you,
      Michael

      Attachments

        Activity

          People

            Unassigned Unassigned
            michaeldg Michaël de groot
            Votes:
            0 Vote for this issue
            Watchers:
            4 Start watching this issue

            Dates

              Created:
              Updated:

              Git Integration

                Error rendering 'com.xiplink.jira.git.jira_git_plugin:git-issue-webpanel'. Please contact your Jira administrators.