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