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

mysqldump options --ignore-table and --ignore-table-data are case-insensitive

    XMLWordPrintable

Details

    • Bug
    • Status: Open (View Workflow)
    • Minor
    • Resolution: Unresolved
    • 10.2, 10.3, 10.4, 10.5, 10.6
    • 10.4, 10.5
    • Scripts & Clients
    • None

    Description

      mysqldump (mariadb-dump has options

        --ignore-table-data=name 
                            Do not dump the specified table data. To specify more
                            than one table to ignore, use the directive multiple
                            times, once for each table. Each table must be specified
                            with both database and table names, e.g.,
                            --ignore-table-data=database.table.
        --ignore-table=name Do not dump the specified table. To specify more than one
                            table to ignore, use the directive multiple times, once
                            for each table.  Each table must be specified with both
                            database and table names, e.g.,
                            --ignore-table=database.table.
      

      Both options are case-insensitive. That is, if we have tables test.A and test.a, then mysqldump ... --ignore-table=test.a will skip both tables, and so will mysqldump ... --ignore-table=test.A.

      This is not universal for mysqldump options. For example, mysqldump ... test --tables A will only dump the table test.A, and mysqldump ... test --tables a will only dump the table test.a. So, treating ignore-table differently is inconsistent.

      Attachments

        Activity

          People

            sanja Oleksandr Byelkin
            elenst Elena Stepanova
            Votes:
            0 Vote for this issue
            Watchers:
            1 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.