Anonymous

Merging 28 tables...
Creating table with command CREATE TABLE 6hour_merge LIKE multisample_format
Altering table with command ALTER TABLE 6hour_merge ENGINE=MERGE UNION=(multisample_3290037142_1169532000_1169545200,multisample_3290037146_1169532000_1169545200,multisample_3290037142_1169532000_1169545200,multisample_3290037146_1169532000_1169545200,multisample_3290037142_1169532000_1169545200,multisample_3290037146_1169532000_1169545200,multisample_3290037142_1169532000_1169545200,multisample_3290037146_1169532000_1169545200,multisample_3290037142_1169532000_1169545200,multisample_3290037146_1169532000_1169545200,multisample_3290037142_1169532000_1169545200,multisample_3290037146_1169532000_1169545200,multisample_3290037142_1169532000_1169545200,multisample_3290037146_1169532000_1169545200,multisample_3290037142_1169532000_1169545200,multisample_3290037146_1169532000_1169545200,multisample_3290037142_1169532000_1169545200,multisample_3290037146_1169532000_1169545200,multisample_3290037142_1169532000_1169545200,multisample_3290037146_1169532000_1169545200,multisample_3290037142_1169532000_1169545200,multisample_3290037146_1169532000_1169545200,multisample_3290037142_1169532000_1169545200,multisample_3290037146_1169532000_1169545200,multisample_3290037142_1169532000_1169545200,multisample_3290037146_1169532000_1169545200,multisample_3290037142_1169532000_1169545200,multisample_3290037146_1169532000_1169545200)
Merged table alteration failed:  Not unique table/alias: 'multisample_3290037142_1169532000_1169545200'


mysql> show create table multisample_3290037142_1169532000_1169545200;
+----------------------------------------------+-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
| Table                                        | Create Table                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                     |
+----------------------------------------------+-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
| multisample_3290037142_1169532000_1169545200 | CREATE TABLE `multisample_3290037142_1169532000_1169545200` (
  `device` int(10) unsigned NOT NULL default '0',
  `stime` int(10) unsigned NOT NULL default '0',
  `srcaddr` int(10) unsigned NOT NULL default '0',
  `dstaddr` int(10) unsigned NOT NULL default '0',
  `nexthop` int(10) unsigned NOT NULL default '0',
  `inifid` smallint(5) unsigned NOT NULL default '0',
  `outifid` smallint(5) unsigned NOT NULL default '0',
  `octs` bigint(20) NOT NULL default '0',
  `pkts` bigint(20) NOT NULL default '0',
  `classid` int(10) unsigned NOT NULL default '0',
  `srcport` smallint(5) unsigned NOT NULL default '0',
  `dstport` smallint(5) unsigned NOT NULL default '0',
  `proto` tinyint(3) unsigned NOT NULL default '0',
  `tos` tinyint(3) unsigned NOT NULL default '0',
  `flags` tinyint(3) unsigned NOT NULL default '0',
  `srcas` smallint(5) unsigned NOT NULL default '0',
  `dstas` smallint(5) unsigned NOT NULL default '0',
  `srcmask` tinyint(3) unsigned NOT NULL default '0',
  `dstmask` tinyint(3) unsigned NOT NULL default '0',
  `applid` int(10) unsigned NOT NULL default '0'
) ENGINE=MyISAM DEFAULT CHARSET=utf8 |
+----------------------------------------------+-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
1 row in set (0.00 sec)