Client Login

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'



Was this answer helpful?

Add to Favourites Add to Favourites

Print this Article Print this Article
Also Read
How can I backup and restore my MySQL databases? (Views: 3408)
What is MySQL? (Views: 3642)
How do I create/delete/edit my databases and users? (Views: 3474)
How do I connect to and use MySQL? (Views: 3480)
Why do I get error message: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' on shell? (Views: 3472)

Powered by WHMCompleteSolution