Bug #93286 mysqldump uses deprecated option "NO_KEY_OPTIONS" in 8.0.13 with --skip-opt

• Submitted: 22 Nov 2018 6:43
• Modified: 22 Nov 2018 7:18
• Reporter: Bharathkumar Hegde
• Status: Verified
• Category: MySQL Server: Command-line Clients
• Severity: S2 (Serious)
• Version: 8.0.13
• OS: CentOS (7)
• CPU Architecture: x86
• Tags: deprecated option, mysqldump

[22 Nov 2018 6:43] Bharathkumar Hegde

Description:
Looks like mysqldump is still using a deprecated option NO_KEY_OPTIONS in MySQL 8.x.
I am not able to us the option --skip-opt. As it fails with following error

Couldn't execute 'SET SQL_QUOTE_SHOW_CREATE=1 ,SQL_MODE=concat(@@sql_mode, _utf8mb4 ',NO_KEY_OPTIONS,NO_TABLE_OPTIONS,NO_FIELD_OPTIONS') ': Variable 'sql_mode' can't be set to the value of 'NO_KEY_OPTIONS' (1231)

How to repeat:
[root@CassRoyale Log_Files]# mysqldump -uroot -p --skip-opt sakila > sakila.dmp

Enter password:

mysqldump: Couldn't execute 'SET SQL_QUOTE_SHOW_CREATE=1 ,SQL_MODE=concat(@@sql_mode, _utf8mb4 ',NO_KEY_OPTIONS,NO_TABLE_OPTIONS,NO_FIELD_OPTIONS') ': Variable 'sql_mode' can't be set to the value of 'NO_KEY_OPTIONS' (1231)

Suggested fix:
Don't use deprecated option in mysqldump.

[22 Nov 2018 6:44] Bharathkumar Hegde

corrected version.

[22 Nov 2018 7:18] MySQL Verification Team

Hello Bharathkumar,

Thank you for the report.

regards,
Umesh