Untitled

--tab=path, -T path

 

           Produce tab-separated text-format data files. For each dumped table, mysqldump creates a tbl_name.sql file that contains the CREATE TABLE

           statement that creates the table, and the server writes a tbl_name.txt file that contains its data. The option value is the directory in

           which to write the files.

 

               Note

               This option should be used only when mysqldump is run on the same machine as the mysqld server. You must have the FILE privilege, and the

               server must have permission to write files in the directory that you specify.

           By default, the .txt data files are formatted using tab characters between column values and a newline at the end of each line. The format

           can be specified explicitly using the --fields-xxx and --lines-terminated-by options.

 

           As of MySQL 5.1.38, column values are converted to the character set specified by the --default-character-set option. Prior to 5.1.38 or if

           no such option is present, values are dumped using the binary character set. In effect, there is no character set conversion. If a table

           contains columns in several character sets, the output data file will as well and you may not be able to reload the file correctly.