采集自定义表结构备份

CREATE TABLE `webpage` (
`id` varchar(190) NOT NULL,
`headers` blob,
`status` int(11) DEFAULT NULL,
`markers` blob,
`parseStatus` blob,
`modifiedTime` bigint(20) DEFAULT NULL,
`prevModifiedTime` bigint(20) DEFAULT NULL,
`score` float DEFAULT NULL,
`typ` varchar(32) CHARACTER SET latin1 DEFAULT NULL,
`batchId` varchar(32) CHARACTER SET latin1 DEFAULT NULL,
`baseUrl` varchar(767) DEFAULT NULL,
`content` longblob,
`title` varchar(2048) DEFAULT NULL,
`productname` varchar(2048) DEFAULT NULL,
`price` varchar(10) DEFAULT NULL,
`navigation` varchar(2048) DEFAULT NULL,
`parameters` varchar(2048) DEFAULT NULL,
`introduction` varchar(2048) DEFAULT NULL,
`hash` varchar(50) DEFAULT NULL,
`isself` varchar(2) DEFAULT NULL,
`reprUrl` varchar(767) DEFAULT NULL,
`fetchInterval` int(11) DEFAULT NULL,
`prevFetchTime` bigint(20) DEFAULT NULL,
`inlinks` mediumblob,
`prevSignature` blob,
`outlinks` mediumblob,
`fetchTime` bigint(20) DEFAULT NULL,
`retriesSinceFetch` int(11) DEFAULT NULL,
`protocolStatus` blob,
`signature` blob,
`metadata` blob,
PRIMARY KEY (`id`)
) ENGINE=InnoDB
ROW_FORMAT=COMPRESSED
DEFAULT CHARSET=utf8mb4;

采集自定义表结构备份

原文：http://www.cnblogs.com/objectchen/p/4380221.html