CREATE TABLE `a1` (`f1` int not null auto_increment primary key); CREATE TRIGGER `a1bd` BEFORE DELETE ON `a1` FOR EACH ROW BEGIN END; CREATE TABLE `t1` (`f1` int not null auto_increment primary key); SET SQL_MODE = 'NO_AUTO_VALUE_ON_ZERO'; INSERT INTO t1 VALUES (0), (1), (2); SET SQL_MODE = ''; select * from t1; --exec $MYSQL_DUMP --routines test >$MYSQLTEST_VARDIR/tmp/bug29788.sql --exec $MYSQL test < $MYSQLTEST_VARDIR/tmp/bug29788.sql select * from t1;