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?

 Print this Article

Also Read

Why do I get error message: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' on shell?

If you get this error message when trying to use mysql command line utility from shell: Can't...

MySQL Database Wizard

cPanel can guide you through the process of setting up a MySQL database, along with the...

How to create and use MySQL database

MySQL Databases Databases offer a method for managing large amounts of information easily...

phpMyAdmin

phpMyAdmin is a third-party tool included with cPanel, used for maniuplating MySQL databases...

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...