[root@localhostdata]# mysqldump -uroot -p123456 jiaowu tutors -T ./bak/
Warning: Using a password on the commandline interface can be insecure.
[root@localhost data]# cat./bak/tutors.sql
-- MySQL dump 10.13 Distrib 5.6.12, for linux-glibc2.5 (x86_64)
--
-- Host: localhost Database: jiaowu
--------------------------------------------------------
-- Server version 5.6.12-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' */;
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE,SQL_MODE='' */;
/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES,SQL_NOTES=0 */;
?
--
-- Table structure for table `tutors`
--
?
DROP TABLE IF EXISTS `tutors`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8*/;
CREATE TABLE `tutors` (
`TID` smallint(5) unsigned NOT NULL AUTO_INCREMENT,
`Tname` varchar(50) NOT NULL,
`Gender` enum('F','M') DEFAULT 'M',
`Age` tinyint(3) unsigned DEFAULT NULL,
UNIQUE KEY `TID` (`TID`)
) ENGINE=InnoDB AUTO_INCREMENT=31 DEFAULTCHARSET=latin1;
/*!40101 SET character_set_client =@saved_cs_client */;
?
/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;
?
/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
/*!40101 SETCHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SETCHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SETCOLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
?
-- Dump completed on 2015-07-17 15:14:21
?
[root@localhostdata]# cat ./bak/tutors.txt
1 HongQigong M 93
2 HuangYaoshi M 63
3 Miejueshitai F 72
4 OuYangfeng M 76
5 YiDeng M 90
6 YuCanghai M 56
7 Jinlunfawang M 67
8 HuYidao M 42
9 NingZhongze F 49
10 TOM F 30
11 DingDian M 25
12 HuFei M 31
13 Xuzhu M 26
18 DingDian M 25
19 HuFei M 31
20 Xuzhu M 26
23 stu0010 M \N
24 stu0012 M \N
25 str000023 M \N
26 str000024 M \N
27 str9999 M \N
28 str9991 M \N
29 str9992 M \N
30 str9993 M \N
?
在向目录中导出文件时，有时候会提示下面错误
[root@localhost data]# mysqldump -uroot-p123456 test2 t4 -T ./bak/
Warning: Using a password onthe command line interface can be insecure.
?
mysqldump: Got error: 1: Can'tcreate/write to file '/usr/local/mysql/data/bak/t4.txt' (Errcode: 13 -Permission denied) when executing 'SELECT INTO OUTFILE'
报出此错是由于目录没有足够权限导致，只需给目录足够权限即可
[root@localhost data]# chownmysql:mysql ./bak/
[root@localhost data]# mysqldump -uroot -p123456 jiaowu tutors -T ./bak/
Warning: Using a password on the command lineinterface can be insecure.
?
?
8) 导出含有中文的数据，不加参数会导致数据中有乱码
?
[root@localhostdata]# mysqldump -uroot -p123456 --compact jiaowu tutors >test5
Warning: Using a password on the commandline interface can be insecure.
[root@localhostdata]# cat test5
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8*/;
CREATE TABLE `tutors` (
`TID` smallint(5) unsigned NOT NULL AUTO_INCREMENT,
`Tname` varchar(200) DEFAULT NULL,
`Gender`enum('F','M') DEFAULT 'M',
`Age` tinyint(3) unsigned DEFAULT NULL,
UNIQUE KEY `TID` (`TID`)
) ENGINE=InnoDB AUTO_INCREMENT=35 DEFAULTCHARSET=latin1;
/*!40101 SET character_set_client =@save