To load a file into the Mysql database table

[david]

Guys,


If you need to load data into a MySQL table, you can use the following steps

mysql -e "LOAD DATA INFILE '/var/lib/mysql/<database>/<filename eg:: .csv, txt, etc>' INTO TABLE <Tablename>" <database_name>