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'
Can I import csv files using Load Data Infile? Print
- 3
Was this answer helpful?
Related Articles
What is MySQL?
MySQL is a very robust database server. It is often used to deliver dynamic content to sites such...
How do I connect to and use MySQL?
To create and connect to a database in cPanel, you can follow these steps:
1. Log in to your...
Can I connect remotely to MySQL database?
Yes! it is possible. For this you have to allow remote access from your control panel, by adding...
How can I backup and restore my MySQL databases?
There are two main ways to back up or restore a MySQL database on our servers: via SSH or the...
How do I create/delete/edit my databases and users?
All administration of your MySQL databases and users can be done through our convenient web based...
