{"id":252,"date":"2016-12-10T17:01:15","date_gmt":"2016-12-10T09:01:15","guid":{"rendered":"https:\/\/blog.freesilo.com\/?p=252"},"modified":"2016-12-10T17:01:15","modified_gmt":"2016-12-10T09:01:15","slug":"mysql%e5%a4%87%e4%bb%bd%e4%b8%8e%e6%81%a2%e5%a4%8d","status":"publish","type":"post","link":"https:\/\/freesilo.com\/?p=252","title":{"rendered":"MYSQL\u5907\u4efd\u4e0e\u6062\u590d"},"content":{"rendered":"

mysqldump\u5de5\u5177\u7528\u6cd5<\/p>\n

1.\u67e5\u770bmysqldump\u5e2e\u52a9mysqldump –help<\/h3>\n

root@chenwx-VirtualBox:\/backup# mysqldump –help<\/p>\n

mysqldump\u00a0 Ver 10.13 Distrib 5.6.28, for debian-linux-gnu (x86_64)<\/p>\n

Copyright (c) 2000, 2015, Oracle and\/or its affiliates. All rights reserved.<\/p>\n

 <\/p>\n

Oracle is a registered trademark of Oracle Corporation and\/or its<\/p>\n

affiliates. Other names may be trademarks of their respective<\/p>\n

owners.<\/p>\n

 <\/p>\n

Dumping structure and contents of MySQL databases and tables.<\/p>\n

Usage: mysqldump [OPTIONS] database [tables]<\/p>\n

OR\u00a0\u00a0\u00a0\u00a0 mysqldump [OPTIONS] –databases [OPTIONS] DB1 [DB2 DB3…]<\/p>\n

OR\u00a0\u00a0\u00a0\u00a0 mysqldump [OPTIONS] –all-databases [OPTIONS]<\/p>\n

 <\/p>\n

2. mysqldump \u5907\u4efd\u5168\u5e93<\/h3>\n

\u5907\u4efd\u5168\u5e93\u81f3\/backup\/fullbackup.sql<\/p>\n

root@chenwx-VirtualBox:\/backup# mysqldump –all-databases > \/backup\/fullbackup.sql<\/p>\n

\u8bf4\u660e\uff1a<\/p>\n

–all-databases\uff1a\u8f6c\u50a8\u6240\u6709\u6570\u636e\u5e93<\/p>\n

>\uff1a\u6307\u5b9a\u8f93\u51fa<\/p>\n

\/backup\/\uff1a\u8def\u5f84<\/p>\n

fullbackup.sql\uff1a\u5907\u4efd\u6587\u4ef6<\/p>\n

 <\/p>\n

3. mysqldump \u5907\u4efdtest \u3001test2\u6570\u636e\u5e93<\/h3>\n

root@chenwx-VirtualBox:\/backup# mysqldump –databases test test2>\/backup\/backuptest.sql<\/p>\n

–database\uff1a\u8f6c\u50a8\u6307\u5b9a\u6570\u636e\u5e93\u591a\u4e2a\u6570\u636e\u5e93\u7528\u7a7a\u683c\u5206\u9694<\/p>\n

\u67e5\u770b\u5907\u4efd\u4fe1\u606f<\/p>\n

root@chenwx-VirtualBox:\/backup# cat backuptest.sql<\/p>\n

— MySQL dump 10.13\u00a0 Distrib 5.6.28, for debian-linux-gnu (x86_64)<\/p>\n

—<\/p>\n

— Host: localhost\u00a0\u00a0\u00a0 Database: test<\/p>\n

— ——————————————————<\/p>\n

— Server version\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 5.6.28-0ubuntu0.15.10.1<\/p>\n

 <\/p>\n

\/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT *\/;<\/p>\n

\/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS *\/;<\/p>\n

\/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION *\/;<\/p>\n

\/*!40101 SET NAMES utf8 *\/;<\/p>\n

\/*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE *\/;<\/p>\n

\/*!40103 SET TIME_ZONE=’+00:00′ *\/;<\/p>\n

\/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 *\/;<\/p>\n

\/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 *\/;<\/p>\n

\/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE=’NO_AUTO_VALUE_ON_ZERO’ *\/;<\/p>\n

\/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 *\/;<\/p>\n

 <\/p>\n

—<\/p>\n

— Current Database: `test`<\/p>\n

—<\/p>\n

 <\/p>\n

CREATE DATABASE \/*!32312 IF NOT EXISTS*\/ `test` \/*!40100 DEFAULT CHARACTER SET latin1 *\/;<\/p>\n

 <\/p>\n

USE `test`;<\/p>\n

 <\/p>\n

—<\/p>\n

— Table structure for table `t`<\/p>\n

—<\/p>\n

 <\/p>\n

DROP TABLE IF EXISTS `t`;<\/p>\n

\/*!40101 SET @saved_cs_client\u00a0\u00a0\u00a0\u00a0 = @@character_set_client *\/;<\/p>\n

\/*!40101 SET character_set_client = utf8 *\/;<\/p>\n

CREATE TABLE `t` (<\/p>\n

`id` int(11) DEFAULT NULL,<\/p>\n

`value` varchar(30) DEFAULT NULL<\/p>\n

) ENGINE=InnoDB DEFAULT CHARSET=utf8;<\/p>\n

\/*!40101 SET character_set_client = @saved_cs_client *\/;<\/p>\n

 <\/p>\n

—<\/p>\n

— Dumping data for table `t`<\/p>\n

—<\/p>\n

 <\/p>\n

LOCK TABLES `t` WRITE;<\/p>\n

\/*!40000 ALTER TABLE `t` DISABLE KEYS *\/;<\/p>\n

INSERT INTO `t` VALUES (1,NULL),(2,”),(3,’100.000.000′),(4,’1000′),(5,’1000\u4e07\u5143’),(6,’\u4e00\u767e\u4e07\u5143’);<\/p>\n

\/*!40000 ALTER TABLE `t` ENABLE KEYS *\/;<\/p>\n

UNLOCK TABLES;<\/p>\n

 <\/p>\n

—<\/p>\n

— Current Database: `test2`<\/p>\n

—<\/p>\n

 <\/p>\n

CREATE DATABASE \/*!32312 IF NOT EXISTS*\/ `test2` \/*!40100 DEFAULT CHARACTER SET utf8 *\/;<\/p>\n

 <\/p>\n

USE `test2`;<\/p>\n

 <\/p>\n

—<\/p>\n

— Table structure for table `t2`<\/p>\n

—<\/p>\n

 <\/p>\n

DROP TABLE IF EXISTS `t2`;<\/p>\n

\/*!40101 SET @saved_cs_client\u00a0\u00a0\u00a0\u00a0 = @@character_set_client *\/;<\/p>\n

\/*!40101 SET character_set_client = utf8 *\/;<\/p>\n

CREATE TABLE `t2` (<\/p>\n

`id` int(11) DEFAULT NULL<\/p>\n

) ENGINE=InnoDB DEFAULT CHARSET=utf8;<\/p>\n

\/*!40101 SET character_set_client = @saved_cs_client *\/;<\/p>\n

 <\/p>\n

—<\/p>\n

— Dumping data for table `t2`<\/p>\n

—<\/p>\n

 <\/p>\n

LOCK TABLES `t2` WRITE;<\/p>\n

\/*!40000 ALTER TABLE `t2` DISABLE KEYS *\/;<\/p>\n

\/*!40000 ALTER TABLE `t2` ENABLE KEYS *\/;<\/p>\n

UNLOCK TABLES;<\/p>\n

\/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE *\/;<\/p>\n

 <\/p>\n

\/*!40101 SET SQL_MODE=@OLD_SQL_MODE *\/;<\/p>\n

\/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS *\/;<\/p>\n

\/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS *\/;<\/p>\n

\/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT *\/;<\/p>\n

\/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS *\/;<\/p>\n

\/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION *\/;<\/p>\n

\/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES *\/;<\/p>\n

 <\/p>\n

— Dump completed on 2016-05-05 10:48:22<\/p>\n

 <\/p>\n

4.mysql\u5907\u4efd\u6307\u5b9a\u6570\u636e\u8868<\/h3>\n

\u8f6c\u50a8test\u6570\u636e\u5e93\u8868t<\/p>\n

root@chenwx-VirtualBox:\/backup# mysqldump test t>\/backup\/testt.sql<\/p>\n

root@chenwx-VirtualBox:\/backup# ll<\/p>\n

\u603b\u7528\u91cf 652<\/p>\n

drwxr-xr-x\u00a0 2 root root\u00a0\u00a0 4096\u00a0 5\u6708\u00a0 5 11:01 .\/<\/p>\n

drwxr-xr-x 24 root root\u00a0\u00a0 4096\u00a0 5\u6708\u00a0 5 09:28 ..\/<\/p>\n

-rw-r–r–\u00a0 1 root root\u00a0\u00a0 2652\u00a0 5\u6708\u00a0 5 10:48 backuptest.sql<\/p>\n

-rw-r–r–\u00a0 1 root root 647363\u00a0 5\u6708\u00a0 5 10:41 fullbackup.sql<\/p>\n

-rw-r–r–\u00a0 1 root root\u00a0\u00a0 1890\u00a0 5\u6708\u00a0 5 11:01 testt.sql<\/p>\n

root@chenwx-VirtualBox:\/backup# cat testt.sql<\/p>\n

— MySQL dump 10.13\u00a0 Distrib 5.6.28, for debian-linux-gnu (x86_64)<\/p>\n

—<\/p>\n

— Host: localhost\u00a0\u00a0\u00a0 Database: test<\/p>\n

— ——————————————————<\/p>\n

— Server version\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 5.6.28-0ubuntu0.15.10.1<\/p>\n

 <\/p>\n

\/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT *\/;<\/p>\n

\/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS *\/;<\/p>\n

\/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION *\/;<\/p>\n

\/*!40101 SET NAMES utf8 *\/;<\/p>\n

\/*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE *\/;<\/p>\n

\/*!40103 SET TIME_ZONE=’+00:00′ *\/;<\/p>\n

\/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 *\/;<\/p>\n

\/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 *\/;<\/p>\n

\/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE=’NO_AUTO_VALUE_ON_ZERO’ *\/;<\/p>\n

\/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 *\/;<\/p>\n

 <\/p>\n

—<\/p>\n

— Table structure for table `t`<\/p>\n

—<\/p>\n

 <\/p>\n

DROP TABLE IF EXISTS `t`;<\/p>\n

\/*!40101 SET @saved_cs_client\u00a0\u00a0\u00a0\u00a0 = @@character_set_client *\/;<\/p>\n

\/*!40101 SET character_set_client = utf8 *\/;<\/p>\n

CREATE TABLE `t` (<\/p>\n

`id` int(11) DEFAULT NULL,<\/p>\n

`value` varchar(30) DEFAULT NULL<\/p>\n

) ENGINE=InnoDB DEFAULT CHARSET=utf8;<\/p>\n

\/*!40101 SET character_set_client = @saved_cs_client *\/;<\/p>\n

 <\/p>\n

—<\/p>\n

— Dumping data for table `t`<\/p>\n

—<\/p>\n

 <\/p>\n

LOCK TABLES `t` WRITE;<\/p>\n

\/*!40000 ALTER TABLE `t` DISABLE KEYS *\/;<\/p>\n

INSERT INTO `t` VALUES (1,NULL),(2,”),(3,’100.000.000′),(4,’1000′),(5,’1000\u4e07\u5143’),(6,’\u4e00\u767e\u4e07\u5143’);<\/p>\n

\/*!40000 ALTER TABLE `t` ENABLE KEYS *\/;<\/p>\n

UNLOCK TABLES;<\/p>\n

\/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE *\/;<\/p>\n

 <\/p>\n

\/*!40101 SET SQL_MODE=@OLD_SQL_MODE *\/;<\/p>\n

\/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS *\/;<\/p>\n

\/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS *\/;<\/p>\n

\/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT *\/;<\/p>\n

\/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS *\/;<\/p>\n

\/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION *\/;<\/p>\n

\/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES *\/;<\/p>\n

 <\/p>\n

— Dump completed on 2016-05-05 11:01:01<\/p>\n

 <\/p>\n

 <\/p>\n

5. \u8f6c\u50a8\u6570\u636e\u5e93test2\u8868t1\u3001t2\u53ca\u6570\u636e<\/h3>\n

root@chenwx-VirtualBox:\/backup# mysqldump test2 t1 t2>\/backup\/test2t1t2.sql<\/p>\n

root@chenwx-VirtualBox:\/backup# cat test2t1t2.sql<\/p>\n

— MySQL dump 10.13\u00a0 Distrib 5.6.28, for debian-linux-gnu (x86_64)<\/p>\n

—<\/p>\n

— Host: localhost\u00a0\u00a0\u00a0 Database: test2<\/p>\n

— ——————————————————<\/p>\n

— Server version\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 5.6.28-0ubuntu0.15.10.1<\/p>\n

 <\/p>\n

\/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT *\/;<\/p>\n

\/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS *\/;<\/p>\n

\/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION *\/;<\/p>\n

\/*!40101 SET NAMES utf8 *\/;<\/p>\n

\/*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE *\/;<\/p>\n

\/*!40103 SET TIME_ZONE=’+00:00′ *\/;<\/p>\n

\/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 *\/;<\/p>\n

\/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 *\/;<\/p>\n

\/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE=’NO_AUTO_VALUE_ON_ZERO’ *\/;<\/p>\n

\/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 *\/;<\/p>\n

 <\/p>\n

—<\/p>\n

— Table structure for table `t1`<\/p>\n

—<\/p>\n

 <\/p>\n

DROP TABLE IF EXISTS `t1`;<\/p>\n

\/*!40101 SET @saved_cs_client\u00a0\u00a0\u00a0\u00a0 = @@character_set_client *\/;<\/p>\n

\/*!40101 SET character_set_client = utf8 *\/;<\/p>\n

CREATE TABLE `t1` (<\/p>\n

`id` int(11) DEFAULT NULL,<\/p>\n

`t1name` varchar(10) DEFAULT NULL<\/p>\n

) ENGINE=InnoDB DEFAULT CHARSET=utf8;<\/p>\n

\/*!40101 SET character_set_client = @saved_cs_client *\/;<\/p>\n

 <\/p>\n

—<\/p>\n

— Dumping data for table `t1`<\/p>\n

—<\/p>\n

 <\/p>\n

LOCK TABLES `t1` WRITE;<\/p>\n

\/*!40000 ALTER TABLE `t1` DISABLE KEYS *\/;<\/p>\n

INSERT INTO `t1` VALUES (1,’t1′),(1,’t11′);<\/p>\n

\/*!40000 ALTER TABLE `t1` ENABLE KEYS *\/;<\/p>\n

UNLOCK TABLES;<\/p>\n

 <\/p>\n

—<\/p>\n

— Table structure for table `t2`<\/p>\n

—<\/p>\n

 <\/p>\n

DROP TABLE IF EXISTS `t2`;<\/p>\n

\/*!40101 SET @saved_cs_client\u00a0\u00a0\u00a0\u00a0 = @@character_set_client *\/;<\/p>\n

\/*!40101 SET character_set_client = utf8 *\/;<\/p>\n

CREATE TABLE `t2` (<\/p>\n

`id` int(11) DEFAULT NULL<\/p>\n

) ENGINE=InnoDB DEFAULT CHARSET=utf8;<\/p>\n

\/*!40101 SET character_set_client = @saved_cs_client *\/;<\/p>\n

 <\/p>\n

—<\/p>\n

— Dumping data for table `t2`<\/p>\n

—<\/p>\n

 <\/p>\n

LOCK TABLES `t2` WRITE;<\/p>\n

\/*!40000 ALTER TABLE `t2` DISABLE KEYS *\/;<\/p>\n

INSERT INTO `t2` VALUES (1),(2);<\/p>\n

\/*!40000 ALTER TABLE `t2` ENABLE KEYS *\/;<\/p>\n

UNLOCK TABLES;<\/p>\n

\/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE *\/;<\/p>\n

 <\/p>\n

\/*!40101 SET SQL_MODE=@OLD_SQL_MODE *\/;<\/p>\n

\/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS *\/;<\/p>\n

\/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS *\/;<\/p>\n

\/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT *\/;<\/p>\n

\/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS *\/;<\/p>\n

\/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION *\/;<\/p>\n

\/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES *\/;<\/p>\n

 <\/p>\n

— Dump completed on 2016-05-05 11:04:21<\/p>\n

 <\/p>\n

 <\/p>\n

 <\/p>\n

6.\u5bfc\u51fa\u6574\u4e2a\u6570\u636e\u5e93\u7ed3\u6784<\/h3>\n

root@chenwx-VirtualBox:\/backup# mysqldump –all-databases -d > alldatabase.sql<\/p>\n

 <\/p>\n

7.\u5bfc\u51fa\u6307\u5b9a\u6570\u636e\u5e93\u7ed3\u6784<\/h3>\n

root@chenwx-VirtualBox:\/backup# mysqldump -d test2 > str_test2.sql<\/p>\n

root@chenwx-VirtualBox:\/backup# cat str_test2.sql<\/p>\n

— MySQL dump 10.13\u00a0 Distrib 5.6.28, for debian-linux-gnu (x86_64)<\/p>\n

—<\/p>\n

— Host: localhost\u00a0\u00a0\u00a0 Database: test2<\/p>\n

— ——————————————————<\/p>\n

— Server version\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 5.6.28-0ubuntu0.15.10.1<\/p>\n

 <\/p>\n

\/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT *\/;<\/p>\n

\/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS *\/;<\/p>\n

\/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION *\/;<\/p>\n

\/*!40101 SET NAMES utf8 *\/;<\/p>\n

\/*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE *\/;<\/p>\n

\/*!40103 SET TIME_ZONE=’+00:00′ *\/;<\/p>\n

\/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 *\/;<\/p>\n

\/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 *\/;<\/p>\n

\/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE=’NO_AUTO_VALUE_ON_ZERO’ *\/;<\/p>\n

\/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 *\/;<\/p>\n

 <\/p>\n

—<\/p>\n

— Table structure for table `t1`<\/p>\n

—<\/p>\n

 <\/p>\n

DROP TABLE IF EXISTS `t1`;<\/p>\n

\/*!40101 SET @saved_cs_client\u00a0\u00a0\u00a0\u00a0 = @@character_set_client *\/;<\/p>\n

\/*!40101 SET character_set_client = utf8 *\/;<\/p>\n

CREATE TABLE `t1` (<\/p>\n

`id` int(11) DEFAULT NULL,<\/p>\n

`t1name` varchar(10) DEFAULT NULL<\/p>\n

) ENGINE=InnoDB DEFAULT CHARSET=utf8;<\/p>\n

\/*!40101 SET character_set_client = @saved_cs_client *\/;<\/p>\n

 <\/p>\n

—<\/p>\n

— Table structure for table `t2`<\/p>\n

—<\/p>\n

 <\/p>\n

DROP TABLE IF EXISTS `t2`;<\/p>\n

\/*!40101 SET @saved_cs_client\u00a0\u00a0\u00a0\u00a0 = @@character_set_client *\/;<\/p>\n

\/*!40101 SET character_set_client = utf8 *\/;<\/p>\n

CREATE TABLE `t2` (<\/p>\n

`id` int(11) DEFAULT NULL<\/p>\n

) ENGINE=InnoDB DEFAULT CHARSET=utf8;<\/p>\n

\/*!40101 SET character_set_client = @saved_cs_client *\/;<\/p>\n

\/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE *\/;<\/p>\n

 <\/p>\n

\/*!40101 SET SQL_MODE=@OLD_SQL_MODE *\/;<\/p>\n

\/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS *\/;<\/p>\n

\/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS *\/;<\/p>\n

\/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT *\/;<\/p>\n

\/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS *\/;<\/p>\n

\/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION *\/;<\/p>\n

\/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES *\/;<\/p>\n

 <\/p>\n

— Dump completed on 2016-05-05 11:21:39<\/p>\n

8.\u5bfc\u51fa\u5355\u4e2a\u8868\u7ed3\u6784<\/h3>\n

root@chenwx-VirtualBox:\/backup# mysqldump -d test2 t2> str_test2t2.sql<\/p>\n

root@chenwx-VirtualBox:\/backup# cat str_test2t2.sql<\/p>\n

— MySQL dump 10.13\u00a0 Distrib 5.6.28, for debian-linux-gnu (x86_64)<\/p>\n

—<\/p>\n

— Host: localhost\u00a0\u00a0\u00a0 Database: test2<\/p>\n

— ——————————————————<\/p>\n

— Server version\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 5.6.28-0ubuntu0.15.10.1<\/p>\n

 <\/p>\n

\/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT *\/;<\/p>\n

\/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS *\/;<\/p>\n

\/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION *\/;<\/p>\n

\/*!40101 SET NAMES utf8 *\/;<\/p>\n

\/*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE *\/;<\/p>\n

\/*!40103 SET TIME_ZONE=’+00:00′ *\/;<\/p>\n

\/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 *\/;<\/p>\n

\/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 *\/;<\/p>\n

\/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE=’NO_AUTO_VALUE_ON_ZERO’ *\/;<\/p>\n

\/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 *\/;<\/p>\n

 <\/p>\n

—<\/p>\n

— Table structure for table `t2`<\/p>\n

—<\/p>\n

 <\/p>\n

DROP TABLE IF EXISTS `t2`;<\/p>\n

\/*!40101 SET @saved_cs_client\u00a0\u00a0\u00a0\u00a0 = @@character_set_client *\/;<\/p>\n

\/*!40101 SET character_set_client = utf8 *\/;<\/p>\n

CREATE TABLE `t2` (<\/p>\n

`id` int(11) DEFAULT NULL<\/p>\n

) ENGINE=InnoDB DEFAULT CHARSET=utf8;<\/p>\n

\/*!40101 SET character_set_client = @saved_cs_client *\/;<\/p>\n

\/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE *\/;<\/p>\n

 <\/p>\n

\/*!40101 SET SQL_MODE=@OLD_SQL_MODE *\/;<\/p>\n

\/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS *\/;<\/p>\n

\/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS *\/;<\/p>\n

\/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT *\/;<\/p>\n

\/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS *\/;<\/p>\n

\/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION *\/;<\/p>\n

\/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES *\/;<\/p>\n

 <\/p>\n

— Dump completed on 2016-05-05 11:23:48<\/p>\n

 <\/p>\n","protected":false},"excerpt":{"rendered":"

mysqldump\u5de5\u5177\u7528\u6cd5 1.\u67e5\u770bmysqldump\u5e2e\u52a9mysqldump &…
Read more<\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[18],"tags":[],"class_list":["post-252","post","type-post","status-publish","format-standard","hentry","category-mysql"],"_links":{"self":[{"href":"https:\/\/freesilo.com\/index.php?rest_route=\/wp\/v2\/posts\/252","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/freesilo.com\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/freesilo.com\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/freesilo.com\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/freesilo.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=252"}],"version-history":[{"count":1,"href":"https:\/\/freesilo.com\/index.php?rest_route=\/wp\/v2\/posts\/252\/revisions"}],"predecessor-version":[{"id":253,"href":"https:\/\/freesilo.com\/index.php?rest_route=\/wp\/v2\/posts\/252\/revisions\/253"}],"wp:attachment":[{"href":"https:\/\/freesilo.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=252"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/freesilo.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=252"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/freesilo.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=252"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}