Bug #77037 mysqldump: Option '-T' used, but is disabled
Submitted: 14 May 2015 9:19 Modified: 26 May 2015 13:12
Reporter: Umesh Shastry Email Updates:
Status: Closed Impact on me:
None 
Category:MySQL Server: mysqldump Command-line Client Severity:S3 (Non-critical)
Version:5.7.7, 5.7.8 OS:Any
Assigned to: CPU Architecture:Any
Tags: regression

[14 May 2015 9:19] Umesh Shastry
Description:
While producing a tab-separated text-format data files using mysqldump observed that -T option is no longer working with 5.7.7/5.7.8.

// Schema used

use test;
drop table if exists t1;
CREATE TABLE `t1` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `dummy` varbinary(50) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=latin1;
insert into t1 values(1,AES_ENCRYPT('mysql','mysql'));

// Try to dump tables using mysqldump with -T option

// 5.5.45 -T/--tab works

[umshastr@hod03]/export/umesh/server/binaries/mysql-5.5.45: bin/mysqldump -uroot -p -S/tmp/mysql_ushastry.sock test -T /tmp/
Enter password:
[umshastr@hod03]/export/umesh/server/binaries/mysql-5.5.45: ls -l /tmp/
.
-rw-r--r-- 1 umshastr common 1406 May 14 08:25 t1.sql
-rw-rw-rw- 1 umshastr common   14 May 14 08:25 t1.txt

// 5.6.26 -T/--tab works

[umshastr@hod03]/export/umesh/server/binaries/mysql-5.6.26: bin/mysqldump -uroot -p -S/tmp/mysql_ushastry.sock test -T /tmp/
Enter password:
[umshastr@hod03]/export/umesh/server/binaries/mysql-5.6.26: ls -l /tmp/t1.*
-rw-r--r-- 1 umshastr common 1412 May 14 08:30 /tmp/t1.sql
-rw-rw-rw- 1 umshastr common   14 May 14 08:30 /tmp/t1.txt

// 5.7.7/5.7.8 - -T is disabled

[umshastr@hod03]/export/umesh/server/binaries/mysql-5.7.8: bin/mysqldump -uroot -p -S/tmp/mysql_ushastry.sock test -T /tmp/
mysqldump: [ERROR] mysqldump: Option '-T' used, but is disabled

^^^ -T is no longer used

// with --tabs

[umshastr@hod03]/export/umesh/server/binaries/mysql-5.7.8: bin/mysqldump -uroot -p -S/tmp/mysql_ushastry.sock test --tab=/tmp/
Enter password:
[umshastr@hod03]/export/umesh/server/binaries/mysql-5.7.8: ls -l /tmp/
total 8
..

-rw-r--r-- 1 umshastr common 1416 May 14 09:00 t1.sql
-rw-rw-rw- 1 umshastr common   14 May 14 09:00 t1.txt

How to repeat:
See decsription

Suggested fix:
Allow -T option as in previous releases
[26 May 2015 13:12] Paul DuBois
Noted in 5.7.8, 5.8.0 changelogs.

For mysqldump, the -T option is supposed to be the short form of the
--tab option, but was mistakenly associated with --debug-info
instead.