Title: csv upload do not work
Last modified: October 13, 2016

---

# csv upload do not work

 *  [vifuturo](https://wordpress.org/support/users/vifuturo/)
 * (@vifuturo)
 * [9 years, 7 months ago](https://wordpress.org/support/topic/csv-upload-do-not-work/)
 * Hello,
 * I’ve tried to upload csv file, as explained, with , and not ; but all the uploads
   returns no data, no records, emply.
    I’ve tried to download the csv created by
   the extension and upload but with same problem: no records are uploaded. Is it
   possible to show a csv correct strutue? Or file demo to download?
 * I’ve tried with these (and others):
    “sdsref”,”field1″,”field2″,”” “1”,””,”2″,””“
   3”,””,”3″,””
 * No sucess
 * Regards
    Peter

Viewing 6 replies - 1 through 6 (of 6 total)

 *  [arete7](https://wordpress.org/support/users/arete7/)
 * (@arete7)
 * [9 years, 6 months ago](https://wordpress.org/support/topic/csv-upload-do-not-work/#post-8413247)
 * Hi,
 * I’m having the same problem. Bug maybe?
 * Thx.
    Paul.
 * Update, MySQL issue
    WordPress database error The used command is not allowed
   with this MySQL version for query LOAD DATA LOCAL INFILE
 * # mysql -V
    mysql Ver 14.14 Distrib 5.5.53
    -  This reply was modified 9 years, 6 months ago by [arete7](https://wordpress.org/support/users/arete7/).
    -  This reply was modified 9 years, 6 months ago by [arete7](https://wordpress.org/support/users/arete7/).
 *  [arete7](https://wordpress.org/support/users/arete7/)
 * (@arete7)
 * [9 years, 6 months ago](https://wordpress.org/support/topic/csv-upload-do-not-work/#post-8413461)
 * Hi,
 * MySQL needs extra config, see [http://dev.mysql.com/doc/refman/5.5/en/load-data-local.html](http://dev.mysql.com/doc/refman/5.5/en/load-data-local.html)
 * Typically you may need to edit your my.cnf file and add
 * [client]
    loose-local-infile=1
 * Please read docs before just enabling this as it does have security implications.
 * Thx
    Paul.
 *  [arete7](https://wordpress.org/support/users/arete7/)
 * (@arete7)
 * [9 years, 6 months ago](https://wordpress.org/support/topic/csv-upload-do-not-work/#post-8421888)
 * Hi,
 * Ok, after much looking reading and trying, I’ve resorted to changing LOAD DATA
   LOCAL INFILE to LOAD DATA INFILE and adding secure-file-priv = “” to my.cnf and
   GRANT FILE ON *.* TO ‘your_db_user’@’localhost’;.
 * As there is much controversy about php 5.5 upwards having some issues(bug possibly)
   that breaks LOAD DATA LOCAL INFILE(see [http://stackoverflow.com/questions/13016797/load-data-local-infile-fails-from-php-to-mysql-on-amazon-rds](http://stackoverflow.com/questions/13016797/load-data-local-infile-fails-from-php-to-mysql-on-amazon-rds)
   to test this).
 * After making the about 3 changes, the upload was successful.
 * HOTH.
 * Paul.
 *  [wyliecoyote26](https://wordpress.org/support/users/wyliecoyote26/)
 * (@wyliecoyote26)
 * [9 years, 4 months ago](https://wordpress.org/support/topic/csv-upload-do-not-work/#post-8607739)
 * Hi Paul,
 * Where is the my.cnf file located?
 * Steve
 *  [adinugrahafr](https://wordpress.org/support/users/adinugrahafr/)
 * (@adinugrahafr)
 * [9 years, 4 months ago](https://wordpress.org/support/topic/csv-upload-do-not-work/#post-8649679)
 * Hi all, this plugin works beautifully. But i always fail to upload csv. there
   is this notification
 * Warning: mysqli_query(): Filename cannot be empty in /home/xxx/public_html/wp-
   includes/wp-db.php on line 1877
 * xxx is my username on cpanel
 * anything to resolve?
    thank you 🙂
 *  [nounours77](https://wordpress.org/support/users/nounours77/)
 * (@nounours77)
 * [9 years, 2 months ago](https://wordpress.org/support/topic/csv-upload-do-not-work/#post-8848471)
 * Having the same problem with MySQL 5.6.33 – MySQL Community Server (GPL).
 * I’m on shared hosting, and think I do not have access to my.cnf. Is there a possibility
   to modify this behaviour in PhpAdmin? How?
    -  This reply was modified 9 years, 2 months ago by [nounours77](https://wordpress.org/support/users/nounours77/).

Viewing 6 replies - 1 through 6 (of 6 total)

The topic ‘csv upload do not work’ is closed to new replies.

 * ![](https://s.w.org/plugins/geopattern-icon/custom-searchable-data-entry-system_834635.
   svg)
 * [Custom Searchable Data Entry System](https://wordpress.org/plugins/custom-searchable-data-entry-system/)
 * [Frequently Asked Questions](https://wordpress.org/plugins/custom-searchable-data-entry-system/#faq)
 * [Support Threads](https://wordpress.org/support/plugin/custom-searchable-data-entry-system/)
 * [Active Topics](https://wordpress.org/support/plugin/custom-searchable-data-entry-system/active/)
 * [Unresolved Topics](https://wordpress.org/support/plugin/custom-searchable-data-entry-system/unresolved/)
 * [Reviews](https://wordpress.org/support/plugin/custom-searchable-data-entry-system/reviews/)

 * 6 replies
 * 5 participants
 * Last reply from: [nounours77](https://wordpress.org/support/users/nounours77/)
 * Last activity: [9 years, 2 months ago](https://wordpress.org/support/topic/csv-upload-do-not-work/#post-8848471)
 * Status: not resolved