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'

  • 2 Users Found This Useful
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?

Please login to your control panel and follow these steps to create the database, user and its...

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