mysqldump -u$u1 -p'$p1' --no-create-info --no-create-db --skip-triggers zabbix $table_name | mysql -h $new_host -u$u2 -p'$p2' zabbix 

| zabbix | Query   |    42 | Waiting for table metadata lock | insert into history_str (itemid,clock,ns,value) values (28202,1433847002,587568794,'core')

| zabbix | Query   |     1 | update                          | INSERT INTO `history_str` VALUES (153554,1428621506,'',582462960)

CREATE TABLE `history` (
  `itemid` bigint(20) unsigned NOT NULL,
  `clock` int(11) NOT NULL DEFAULT '0',
  `value` double(16,4) NOT NULL DEFAULT '0.0000',
  `ns` int(11) NOT NULL DEFAULT '0',
  KEY `history_1` (`itemid`,`clock`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin

CREATE TABLE `history_log` (
  `id` bigint(20) unsigned NOT NULL,
  `itemid` bigint(20) unsigned NOT NULL,
  `clock` int(11) NOT NULL DEFAULT '0',
  `timestamp` int(11) NOT NULL DEFAULT '0',
  `source` varchar(64) COLLATE utf8_bin NOT NULL DEFAULT '',
  `severity` int(11) NOT NULL DEFAULT '0',
  `value` text COLLATE utf8_bin NOT NULL,
  `logeventid` int(11) NOT NULL DEFAULT '0',
  `ns` int(11) NOT NULL DEFAULT '0',
  KEY `history_log_1` (`itemid`,`clock`),
  KEY `history_log_0` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin

mysqldump --routines --opt --single-transaction --skip-lock-tables --extended-insert=FALSE

  `clock` int(11) NOT NULL DEFAULT '0',
  `timestamp` int(11) NOT NULL DEFAULT '0',

 | zabbix | Query   |    42 | Waiting for table metadata lock | insert into history_str (itemid,clock,ns,value) values (28202,1433847002,587568794,'core')

LOCK TABLES `history_str` WRITE;