What i do:
- Have two connections defined in heidiSQL for example serverA serverB
- Tools -> export database as sql
- choose database on server A (dbexample) checked all objects in it
- create empty dbexample on serverB
- on tab SQL export set: database: create, table create, data: no data, output: server serverB, database: dbexample
and problem
on serverA i got SQL_MODE=STRICT_TRANS_TABLES,NO_ENGINE_SUBSTITUTION for porcedures, triggers and functions
select a.TRIGGER_NAME, a.SQL_MODE from information_schema.TRIGGERS a where a.TRIGGER_SCHEMA='dbexample';
select a.SPECIFIC_NAME, a.SQL_MODE from information_schema.ROUTINES a where a.ROUTINE_SCHEMA='dbexample' && a.ROUTINE_TYPE='function';
select a.SPECIFIC_NAME, a.SQL_MODE from information_schema.ROUTINES a where a.ROUTINE_SCHEMA='dbexample' && a.ROUTINE_TYPE='procedure';
after export on serverB
the same query shows SQL_MODE=NO_AUTO_VALUE_ON_ZERO
please explain or fix this
many thanks Mark