JAVA实现数据库备份与还原(4)

return backupStr;

}

mysqlhotcopy程序,MYSQL 5.1的参考手册的说明："如果你在服务器上进行备份，并且表均为MyISAM表,它运行在Unix和NetWare中"

实现原理和mysqldump一样，这里暂不详细说明

附上mysqldump备份后的文件的内容：DROP TAB

XML/HTML代码

CREATE TABLE `category` (

`category_id` int(11) NOT NULL auto_increment,

`name` varchar(20) NOT NULL,

`parent` int(11) default NULL,

PRIMARY KEY (`category_id`)

)ENGINE=MyISAM DEFAULTCHARSET=latin1 ROW_FORMAT=REDUNDANT;

--

-- Dumping data for table `category`

--

/*!40000 ALTER TABLE `category` DISABLE KEYS */;

LOCK TABLES `category` WRITE;

INSERT INTO `category` VALUES (1,'ELECTRONICS',NULL),(2,'TELEVISIONS',1),(3,'TUBE',2),(4,'LCD',2),(5,'PLASMA',2),(6,'PORTABLE ELECTRONICS',1),(7,'MP3 PLAYERS',6),(8,'FLASH',7),(9,'CD PLAYERS',6),(10,'2 WAY RADIOS',6);

UNLOCK TABLES;

/*!40000 ALTER TABLE `category` ENABLE KEYS */;