#!/bin/bash
#title          :Export - MySQL to .tsv
#description    :This script will generate a .tsv file for each table from MySQL database.
#author         :Weryques S. Silva
#date           :01/09/2017
#version        :1.0

user='user'
password='password'
database='database-name'
directory='/path/to/anywhere/'
encoding='utf8mb4'
#host='localhost'
#port=3306

mysqldump --single-transaction -u $user -p$password -T $directory --fields-enclosed-by='"' --default-character-set=$encoding $database

rm *.sql

tables=$(mysql -u $user -p$password $database -sN -e "SHOW TABLES;")

for table in $tables; do

	mysql -u $user -p$password -e "SELECT GROUP_CONCAT(COLUMN_NAME SEPARATOR '\t') FROM INFORMATION_SCHEMA.COLUMNS WHERE table_schema='$database' and table_name='$table' INTO OUTFILE '$directory$table.tsv' FIELDS TERMINATED BY ',' OPTIONALLY ENCLOSED BY '';"

	cat  $table.txt >> $table.tsv && rm $table.txt

done