-d
只生成创建表结构的语句
mysqldump -uroot -p123456 -d lmis md_goods_type > goods_d.sql
cat goods_d.sql
DROP TABLE IF EXISTS `md_goods_type`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `md_goods_type` (
`ID` varchar(40) NOT NULL,
`code` varchar(40) NOT NULL,
`type` varchar(60) NOT NULL,
`is3c` varchar(10) NOT NULL COMMENT '0:否/1:是',
`remark` varchar(255) DEFAULT NULL,
`status` varchar(4) NOT NULL COMMENT '1:生效/0:失效',
`create_time` datetime DEFAULT NULL,
`create_user` varchar(40) DEFAULT NULL,
`modify_time` datetime DEFAULT NULL,
`modify_user` varchar(40) DEFAULT NULL,
PRIMARY KEY (`ID`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
-t
只生成插入数据的语句
mysqldump -uroot -p123456 -t lmis md_goods_type > goods_t.sql
cat goods_t.sql
LOCK TABLES `md_goods_type` WRITE;
/*!40000 ALTER TABLE `md_goods_type` DISABLE KEYS */;
INSERT INTO `md_goods_type` VALUES ('1A9ACDFFCBBE4D0885A086D1CE46E29F','HWLX_ZJ','灶具','1','','1','2015-05-29 14:10:48','user1',NULL,NULL),('1CDB101AE32F4761B4420BE188F643B1','HWLX_DN','电脑','1','','1','2015-05-29 14:09:01','user1',NULL,NULL),('828A52D2453A4FB18B63F74C153A53CB','HWLX_YJ','烟机','1','','1','2015-05-29 14:10:40','user1',NULL,NULL),('C98D2632A80B4B00A28410D6B468F871','HWLX_KT','空调','1','','1','2015-05-29 14:09:24','user1',NULL,NULL);
/*!40000 ALTER TABLE `md_goods_type` ENABLE KEYS */;
UNLOCK TABLES;
-T
-T必须加目录,且不用重定向某个文件,自动生成两个文件:一个.sql文件,创建表结构的语句;一个.txt文件,数据文件,相当于select into outfile
mysqldump -uroot -p123456 -T /tmp lmis md_goods_type
cat md_goods_type.sql
DROP TABLE IF EXISTS `md_goods_type`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `md_goods_type` (
`ID` varchar(40) NOT NULL,
`code` varchar(40) NOT NULL,
`type` varchar(60) NOT NULL,
`is3c` varchar(10) NOT NULL COMMENT '0:否/1:是',
`remark` varchar(255) DEFAULT NULL,
`status` varchar(4) NOT NULL COMMENT '1:生效/0:失效',
`create_time` datetime DEFAULT NULL,
`create_user` varchar(40) DEFAULT NULL,
`modify_time` datetime DEFAULT NULL,
`modify_user` varchar(40) DEFAULT NULL,
PRIMARY KEY (`ID`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
cat md_goods_type.txt
1A9ACDFFCBBE4D0885A086D1CE46E29F HWLX_ZJ 灶具 1 1 2015-05-29 14:10:48 user1 \N \N
1CDB101AE32F4761B4420BE188F643B1 HWLX_DN 电脑 1 1 2015-05-29 14:09:01 user1 \N \N
828A52D2453A4FB18B63F74C153A53CB HWLX_YJ 烟机 1 1 2015-05-29 14:10:40 user1 \N \N
C98D2632A80B4B00A28410D6B468F871 HWLX_KT 空调 1 1 2015-05-29 14:09:24 user1 \N \N
可以格式化数据文件,比如字段用双引号引起,字段之前使用逗号隔开
mysqldump -uroot -p123456 -T /tmp lmis md_goods_type --fields-enclosed-by=\" --fields-terminated-by=,
cat md_goods_type.txt
"1A9ACDFFCBBE4D0885A086D1CE46E29F","HWLX_ZJ","灶具","1","","1","2015-05-29 14:10:48","user1",\N,\N
"1CDB101AE32F4761B4420BE188F643B1","HWLX_DN","电脑","1","","1","2015-05-29 14:09:01","user1",\N,\N
"828A52D2453A4FB18B63F74C153A53CB","HWLX_YJ","烟机","1","","1","2015-05-29 14:10:40","user1",\N,\N
"C98D2632A80B4B00A28410D6B468F871","HWLX_KT","空调","1","","1","2015-05-29 14:09:24","user1",\N,\N