mysql加快备份_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