Skip to content
  • Bharathy Satish's avatar
    f518bd94
    Bug #27931181: RESTAURE DUMP CREATED WITH 5.7.22 ON 8.0.11 · f518bd94
    Bharathy Satish authored
    Problem: Dump taken using 5.7 server cannot be restored on 8.0.
    
    Analysis: DDLs of triggers, events or procedures have sql_mode set.
    NO_AUTO_CREATE_USER sql_mode is also set along with the definitions.
    This sql mode is removed from 8.0 thus restore of the dump file on 8.0
    server fails.
    
    Fix: Fix is to parse the sql_mode, look for NO_AUTO_CREATE_USER and remove
    it when taking a dump of triggers, events or procedures.
    f518bd94
    Bug #27931181: RESTAURE DUMP CREATED WITH 5.7.22 ON 8.0.11
    Bharathy Satish authored
    Problem: Dump taken using 5.7 server cannot be restored on 8.0.
    
    Analysis: DDLs of triggers, events or procedures have sql_mode set.
    NO_AUTO_CREATE_USER sql_mode is also set along with the definitions.
    This sql mode is removed from 8.0 thus restore of the dump file on 8.0
    server fails.
    
    Fix: Fix is to parse the sql_mode, look for NO_AUTO_CREATE_USER and remove
    it when taking a dump of triggers, events or procedures.
Loading