From https://mariadb.com/kb/en/library/show-create-table/,
I read

MariaDB and MySQL-specific table options, column options, and index options are not included in the output of this statement if the NO_TABLE_OPTIONS, NO_FIELD_OPTIONS and NO_KEY_OPTIONS SQL_MODE flags are used.

I am not sure NO_TABLE_OPTIONS, NO_FIELD_OPTIONS and NO_KEY_OPTIONS SQL_MODE change only the grammar or change database content.
Is database resource from mysqldump --NO_TABLE_OPTIONS --NO_FIELD_OPTIONS --NO_KEY_OPTIONS SQL_MODE --databases db1 same as resource from mysqldump --databases db1?

1 Answer 1


mysqldump reads the database, but does not write to it. It writes a text file you can look at.

You will find that those options remove certain settings relating character set, engine, auto_increment, etc. These may make the generated SQL more compatible with some other database vendor or MySQL/MariaDB version.

The syntax I found was more like

mysqldump --compatible=no_table_options,no_field_options,no_key_options ...

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.