BUG: export databas into another server

alfiqmiq's profile image alfiqmiq posted 8 years ago in General Permalink

What i do:

  1. Have two connections defined in heidiSQL for example serverA serverB
  2. Tools -> export database as sql
  3. choose database on server A (dbexample) checked all objects in it
  4. create empty dbexample on serverB
  5. 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

Please login to leave a reply, or register at first.