importing csvs via mysql cli

Importing CSVs into a MySQL table from the terminal

Recently I ran into a situation where I needed to import a large CSV file into a MySQL database table DreamHost. Since my new computer wasn’t properly set up I decided to convert from CSV to SQL, and PhpMyAdmin would simply 504, I decided to try an approach that only required the terminal.