• Venkatesh Duggirala's avatar
    Bug#14236170 MYSQLDUMP 5.5.25 CLIENT FAILS TO DUMP · b1d16d7e
    Venkatesh Duggirala authored
    MYSQL DB FROM REMOTE 5.0.96 SERVER
    
    Problem: mysqldump tool assumes the existence of
    general_log and slow_log tables in the server.
    If mysqldump tool executes on a old server where
    there are no log tables like these, mysqldump tool
    fails.
    
    Analysis: general_log and slow_log tables are added
    in the ignore-table list as part of bug-26121 fix
    causes bug-45740 (MYSQLDUMP DOESN'T DUMP GENERAL_LOG
    AND SLOW_QUERY CAUSES RESTORE PROBLEM). As part of
    the bug-45740 fix, mysqldump tool adds create table
    queries for these two tables. But the fix assumes
    that on all the servers, general_log and slow_log
    will be there. If the new mysqldump tool is executed
    against a old server where there are no general_log
    and slow_log, the mysqldump tool fails with an error
    that 'there is no general_log table'.
    
    Fix: When mysqldump tool is trying to retrieve general_log
    and slow_log table structures, first the tool should
    check their existence of these tables in the server
    instead of trying to dump it blindly.
    b1d16d7e
mysqldump.c 171 KB