Bug #89611 mysqldump parameter to exclude AUTO_INCREMENT=# table option
Submitted: 9 Feb 2018 16:43 Modified: 6 Oct 2020 13:00
Reporter: Federico Razzoli (OCA) Email Updates:
Status: Duplicate Impact on me:
None 
Category:MySQL Server: mysqldump Command-line Client Severity:S4 (Feature request)
Version: OS:Any
Assigned to: CPU Architecture:Any

[9 Feb 2018 16:43] Federico Razzoli 
Description:
Dumps can be used to track schema (--no-data) in a repository. In this case, developers can generate dumps from the same MySQL instances that they use to test their code.

The problem is that AUTO_INCREMENT always grows (because of their tests), resulting in several junk diffs that lead to wastes of time in several ways.

Excluding it with --no-create-info is not a viable solution, because other table options must be tracked (character set, collation, engine, comment...).

Please provide a way to only exclude AUTO_INCREMENT.

How to repeat:
Work in a company which develops applications that use databases?
[10 Feb 2018 7:46] MySQL Verification Team 
https://www.youtube.com/watch?v=oAiVsbXVP6k
[6 Oct 2020 13:00] MySQL Verification Team 
Hi Mr. Razzoli,

This is a duplicate of the bug #20876.
[6 Oct 2020 13:01] MySQL Verification Team 
Sorry, of the bug #20786.