Knowledgebase
Search:     Advanced search
Browse by category:
Contact Us

Can I import csv files using Load Data Infile?

Views: 77
Votes: 0
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'
Others in this Category
document How do I connect to and use MySQL?
document Can I connect remotely to MySQL database?
document How can I backup and restore my MySQL databases?
document How do I create/delete/edit my databases and users?
document Why do I get error message: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' on shell?
document What is MySQL?
document Which version of MySQL is available?



RSS