MySQL Dump to/Import from CSV

mysqldump_mysqlimport_csv.md

Export the table structure

mysqldump -d --skip-triggers --skip-events --skip-routines {database} > structure.sql

Export tables as CSV

mysqldump -t --fields-enclosed-by='"' --fields-escaped-by='\' --fields-terminated-by='\n' --lines-terminated-by='\n' --tab {absoluteTargetDir} {database}

Import structure

cat structure.sql | mysql {database}

Import table data

mysql -e "SET GLOBAL FOREIGN_KEY_CHECKS=0";
mysqlimport --fields-enclosed-by='"' --fields-escaped-by='\' --fields-terminated-by='\n' --lines-terminated-by='\n' --use-threads={numberOfCpuCores} {database} {absoluteTargetDir}/*.txt
mysql -e "SET GLOBAL FOREIGN_KEY_CHECKS=1";