MySQL Reference Manual :: 8.8 The mysqldump Database Backup Program

MySQL Reference Manual :: 8.8 The mysqldump Database Backup Program

Generate backups of your mysql database in CSV or TAB delimited format

you can use following command

Generate CSV file
This will generate table_name.txt as the CSV and table_name.sql as table creation script

mysqldump -T /folder_path --fields-terminated-by=',' --fields-enclosed-by='"' --lines-terminated-by='\r\n' -u root -p database_name table_name

Generate TAB delimited file
This will generate table_name.txt as the CSV and table_name.sql as table creation script

mysqldump -T /folder_path -u root -p database_name table_name