|NO.Z.00074|——————————|BigDataEnd|——|Java&MySQL索引/存储过程/触发器.V15|——|MySQL.v15|数据库备份_SQL_命令行方式|

一、数据库备份_命令行方式

### --- 命令行备份
——>        进入到Mysql安装目录的 bin目录下, 打开DOS命令行.
——>        语法格式

mysqldump -u 用户名 -p 密码 数据库 > 文件路径

### --- 执行备份, 备份db2中的数据 到 H盘的 db2.sql 文件中

mysqldump -uroot -p123456 db2 > H:/db2.sql

二、命令行恢复

### --- 命令行恢复
### --- 先删除 db2 数据库

### --- 恢复数据 还原 db2 数据库中的数据
——>        注意：还原的时候需要先创建一个 db2数据库

source sql文件地址

三、sql语句

### --- sql语句

-- MySQL dump 10.13  Distrib 5.7.28, for Win64 (x86_64)
--
-- Host: localhost    Database: db2
-- ------------------------------------------------------
-- Server version   5.7.28-log

/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8 */;
/*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;
/*!40103 SET TIME_ZONE='+00:00' */;
/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;

--
-- Table structure for table `account`
--

DROP TABLE IF EXISTS `account`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `account` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `NAME` varchar(10) DEFAULT NULL,
  `money` double DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `account`
--

LOCK TABLES `account` WRITE;
/*!40000 ALTER TABLE `account` DISABLE KEYS */;
INSERT INTO `account` VALUES (1,'tom',1500),(2,'jack',1000),(3,'lucy',1000);
/*!40000 ALTER TABLE `account` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `emp`
--

DROP TABLE IF EXISTS `emp`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `emp` (
  `eid` int(11) DEFAULT NULL,
  `ename` varchar(20) DEFAULT NULL,
  `sex` char(1) DEFAULT NULL,
  `salary` double DEFAULT NULL,
  `hire_date` date DEFAULT NULL,
  `dept_name` varchar(20) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `emp`
--

LOCK TABLES `emp` WRITE;
/*!40000 ALTER TABLE `emp` DISABLE KEYS */;
INSERT INTO `emp` VALUES (1,'孙悟空','男',7200,'2013-02-04','教学部'),(2,'猪八戒','男',3600,'2010-12-02','教学部'),(3,'唐僧','男',9000,'2008-08-08','教学部'),(4,'白骨精','女',5000,'2015-10-07','市场部'),(5,'蜘蛛精','女',5000,'2011-03-14','市场部'),(6,'玉兔精','女',200,'2000-03-14','市场部'),(7,'林黛玉','女',10000,'2019-10-07','财务部'),(8,'黄蓉','女',3500,'2011-09-14','财务部'),(9,'吴承恩','男',20000,'2000-03-14',NULL),(9,NULL,'女',NULL,NULL,'教学部');
/*!40000 ALTER TABLE `emp` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `emp2`
--

DROP TABLE IF EXISTS `emp2`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `emp2` (
  `eid` int(11) NOT NULL AUTO_INCREMENT,
  `ename` varchar(20) NOT NULL,
  `sex` char(1) DEFAULT NULL,
  PRIMARY KEY (`eid`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `emp2`
--

LOCK TABLES `emp2` WRITE;
/*!40000 ALTER TABLE `emp2` DISABLE KEYS */;
INSERT INTO `emp2` VALUES (1,'张三','男'),(2,'李四','女');
/*!40000 ALTER TABLE `emp2` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `emp3`
--

DROP TABLE IF EXISTS `emp3`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `emp3` (
  `eid` int(11) NOT NULL,
  `ename` varchar(20) DEFAULT NULL,
  `sex` char(1) DEFAULT NULL,
  PRIMARY KEY (`eid`),
  UNIQUE KEY `ename` (`ename`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `emp3`
--

LOCK TABLES `emp3` WRITE;
/*!40000 ALTER TABLE `emp3` DISABLE KEYS */;
INSERT INTO `emp3` VALUES (1,'张百万','女'),(2,NULL,'女');
/*!40000 ALTER TABLE `emp3` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `emp4`
--

DROP TABLE IF EXISTS `emp4`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `emp4` (
  `eid` int(11) NOT NULL,
  `ename` varchar(20) DEFAULT NULL,
  `sex` char(1) DEFAULT '女',
  PRIMARY KEY (`eid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `emp4`
--

LOCK TABLES `emp4` WRITE;
/*!40000 ALTER TABLE `emp4` DISABLE KEYS */;
INSERT INTO `emp4` VALUES (1,'杨幂','女'),(2,'柳岩','女'),(3,'蔡徐坤','男');
/*!40000 ALTER TABLE `emp4` ENABLE KEYS */;
UNLOCK TABLES;
/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;

/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;

-- Dump completed on 2020-05-19 11:08:07

---

 

 

 

 

 

 

 

 

 

---

Walter Savage Landor:strove with none,for none was worth my strife.Nature I loved and, next to Nature, Art:I warm'd both hands before the fire of life.It sinks, and I am ready to depart

                                                                                                                                                   ——W.S.Landor

---