• Nisha Gopalakrishnan's avatar
    BUG#15844882: MYSQLDUMP FROM 5.5 FAILS WITH AN ERROR WHEN TRYING · 30a37ca9
    Nisha Gopalakrishnan authored
                  TO DUMP DATA FROM MYSQL-5.6
    
    Analysis
    --------
    Dumping mysql-5.6 data using mysql-5.1/mysql-5.5 'myqldump'
    utility fails with a syntax error.
    
    Server system variable 'sql_quote_show_create' which quotes the
    identifiers is set in the mysqldump utility. The mysldump utility
    of mysql-5.1/mysql-5.5 uses deprecated syntax 'SET OPTION' to set
    the 'sql_quote_show_create' option. The support for the syntax is
    removed in mysql-5.6. Hence syntax error is reported while taking
    the dump.
    
    Fix:
    ---
    Changed the 'mysqldump' code to use the syntax
    'SET SQL_QUOTE_SHOW_CREATE' to set the 'sql_quote_show_create'
    option. That syntax is supported on mysql-5.1, mysql-5.5 and
    mysql-5.6.
    
    NOTE: I have not added an mtr test case since it is difficult
    to simulate the condition. Also the syntax may not be further
    simplified in the future.
    30a37ca9
mysqldump.c 164 KB