mysql 快速备份和还原

窗口cmd执行

• 备份

mysqldump -u root -h 10.88.99.8 -p --databases 数据库1  数据库2 数据库 3 > backdb.sql

生成的语句类似：

CREATE DATABASE /*!32312 IF NOT EXISTS*/ `zyws-employer-base` /*!40100 DEFAULT CHARACTER SET utf8 */;

USE `zyws-employer-base`;

--
-- Table structure for table `tb_hazards_factor`
--

DROP TABLE IF EXISTS `tb_hazards_factor`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `tb_hazards_factor` (
  `RID` bigint(20) NOT NULL AUTO_INCREMENT COMMENT 'RID',
  `CREATE_TIME` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  `CREATE_USER` bigint(20) NOT NULL DEFAULT '1' COMMENT '创建人',
  `MODIFY_TIME` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '修改时间',
  `MODIFY_USER` bigint(20) NOT NULL DEFAULT '1' COMMENT '修改人',
  `IF_DELETE` tinyint(1) NOT NULL DEFAULT '0' COMMENT '是否删除',
  `DELETE_TIME` datetime DEFAULT NULL COMMENT '删除时间',
  `DELETE_USER` bigint(20) DEFAULT NULL COMMENT '删除人',
  `HAZARDS_TYPE` char(4) DEFAULT NULL COMMENT '危害因素大类',
  PRIMARY KEY (`RID`) USING BTREE,
  KEY `FK_TB_HAZARDS_FACTOR` (`EMPLOYEE_ID`) USING BTREE,
  CONSTRAINT `FK_TB_HAZARDS_FACTOR` FOREIGN KEY (`EMPLOYEE_ID`) REFERENCES `td_employer_basic` (`RID`)
) ENGINE=InnoDB AUTO_INCREMENT=16 DEFAULT CHARSET=utf8 COMMENT='单位职业病危害因素';
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `tb_hazards_factor`
--

LOCK TABLES `tb_hazards_factor` WRITE;
/*!40000 ALTER TABLE `tb_hazards_factor` DISABLE KEYS */;
INSERT INTO `tb_hazards_factor` VALUES (1,.......);
/*!40000 ALTER TABLE `tb_hazards_factor` ENABLE KEYS */;
UNLOCK TABLES;

• 还原

mysql -u root -h 10.88.99.9 -p --default-character-set=utf8  < backdb.sql