[MDEV-14065] MySQLdump order by and select column features Created: 2017-10-13  Updated: 2017-10-13

Status: Open
Project: MariaDB Server
Component/s: Backup
Fix Version/s: None

Type: Task Priority: Major
Reporter: Michaël de groot Assignee: Unassigned
Resolution: Unresolved Votes: 0
Labels: 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


Generated at Thu Feb 08 08:10:39 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.