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

MySQLdump order by and select column features

    XMLWordPrintable

Details

    • Task
    • Status: Open (View Workflow)
    • Major
    • Resolution: Unresolved
    • None
    • Backup
    • None

    Description

      Hi,

      I am running innodb_force_recovery=6 because there is some corruption. To be able to retrieve as much data as possible I would like to orer by primary key DESCENDING. MySQLdump only supports order by priimary key ascending.

      Feature request 1: Make it possible to sort by primary key but DESCENDING.

      Also, it could be that valuable data exists in secondary indexes. I would like to be able to sort by these indexes as well. Also, to not go back to the (corrupted) clustered index we would need to be able to select certain columns only.

      Feature request 2: Make it possible to SELECT only certain columns
      Feature request 3: Make it possible to order by a secondary index, e.g. specify the exact order by clause

      Attachments

        Activity

          People

            Unassigned Unassigned
            michaeldg Michaël de groot
            Votes:
            0 Vote for this issue
            Watchers:
            2 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.