Export table from MySQL database to Tab-separated value (TSV) file (bash/sh one-liner)

export_mysql_table_to_tsv.sh

#!/usr/bin/env bash

DB_HOST=localhost
DB_NAME=database
DB_USER=user
DB_PASSWORD=p@ssw0rd
DB_TABLE=some_table

mysql --host=$DB_HOST --user=$DB_USER --password=$DB_PASSWORD --execute="select * from $DB_NAME.$DB_TABLE;" > sql_dump_$DB_NAME_$DB_TABLE.tsv
exit

#
# Using mysqldump: in case of error writing files, check the directory where MySQL is allowed to export files by
#     SHOW VARIABLES LIKE "secure_file_priv";
# and use it instead of /path/to/the/dir in the command below
#
# Both MySQL and user running command should be allowed to write to the directory /path/to/the/dir
#
mysqldump --host=$DB_HOST --user=$DB_USER --password=$DB_PASSWORD --tab=/path/to/the/dir \
    --fields-enclosed-by='"' --fields-terminated-by=',' --lines-terminated-by='\n' \
    $DB_NAME $DB_TABLE