mysqldump-to-csv.sql

# This script gets mysql table to csv 
# To use you need to run this on bash using the collosing command "mysql -h "server-name" -u "root" "-pXXXXXXXX" "database-name" < "mysqldump-to-csv.sql""
# replace t1 with table name PREFIX for the file name

SET @TS = DATE_FORMAT(NOW(),'_%Y_%m_%d_%H_%i_%s');
 
SET @FOLDER = '/tmp/';
SET @PREFIX = 'name';
SET @EXT    = '.csv';
 
SET @CMD = CONCAT("SELECT * FROM t1 INTO OUTFILE '",@FOLDER,@PREFIX,@TS,@EXT,
    "' FIELDS ENCLOSED BY '\"' TERMINATED BY ';' ESCAPED BY '\"'",
    "  LINES TERMINATED BY '\r\n';");
 
PREPARE statement FROM @CMD;
 
EXECUTE statement;