MySQL Bugs: #80735: mysqldump where clause won't allow selection by partition

Bug #80735	mysqldump where clause won't allow selection by partition
Submitted:	14 Mar 2016 19:25
Reporter:	Randy Bies	Email Updates:
Status:	Open	Impact on me:	None
Category:	MySQL Server: mysqldump Command-line Client	Severity:	S4 (Feature request)
Version:	5.6	OS:	Any
Assigned to:		CPU Architecture:	Any
Tags:	mysqldump, partitions

View
Add Comment
Files
Developer
Edit Submission
View Progress Log
Contributions

Description:
Would like to be able to specify a partition list for mysqldump. In 5.6, querying by specific partition(s) was added to various SQL statements such as select. It was added as a sub-clause to the table specification. An analogous type of addition would be very helpful for mysqldump in addition to the existing where clause functionality to allow dumping of specific partitions rather than having to create a where clause that duplicates the partition definition behavior.

How to repeat:
Nothing to repeat, syntax doesn't exist for mysqldump to do this.

Suggested fix:
Add a separate argument for specifying partition(s) to dump.