-
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.
Bharathy Satish authoredProblem: 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