Comment 2 for bug 1533722

Revision history for this message
Fungo Wang (fungo) wrote :

BTW, such backup set can be constructed by creating table like this:

CREATE TABLE `sbtest1` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `k` int(10) unsigned NOT NULL DEFAULT '0',
  `c` char(120) CHARACTER SET utf8 COLLATE utf8_general50_ci NOT NULL DEFAULT '',
  `pad` char(60) NOT NULL DEFAULT '',
  PRIMARY KEY (`id`),
  KEY `k_1` (`k`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

and then take a backup.
During backup, please update this table sbtest1 frequently, such as using sysbench.