Export options for auto_increment and DEFINER

[datlechin]

Problem

An SQL export writes AUTO_INCREMENT=<n> into CREATE TABLE and a DEFINER= clause into every view, trigger and routine. Both make the file server-specific: the auto-increment value is noise in a schema diff, and the DEFINER names a user that does not exist on the target, so the import fails outright.

Proposed solution

• An Exclude AUTO_INCREMENT option in the SQL export, on by default for a structure-only export.
• An Ignore DEFINER option that drops the clause, letting the importing user own the object.
• Both remembered with the rest of the format's options.

Alternatives considered

sed the dump file afterwards.

Related database type

MySQL / MariaDB