ICCM Hosting

MySQL Hosting

Can I import csv files using Load Data Infile?

This feature is not supported by cpanel but you can ask support to add File_priv to your db user that needs to import csv files. After that you can use this format on mysql command line utility via ssh:

LOAD DATA LOCAL INFILE 'upload.txt' INTO TABLE mydatabase.mytable FIELDS TERMINATED BY ',' LINES TERMINATED BY '\\n'