Knowledgebase
Categories
Categories
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?
Also Read
There are two main ways to back up or restore a MySQL database on our servers: via SSH or the...
MySQL Databases Databases offer a method for managing large amounts of information easily...
Please login to your control panel and follow these steps to create the database, user and its...
MySQL is an open source relational database management system. MySQL is noted mainly for its...
cPanel can guide you through the process of setting up a MySQL database, along with the...


