LOAD DATA LOCAL INFILE
そこそこのテキストを一括importしたくていろいろ試したがxampp上でだけなぜかエラーになる
General error: 2000 LOAD DATA LOCAL INFILE is forbidden, check mysqli.allow_local_infile
いろいろ探したらどこかの誰かがこんな事言ってた
Easiest solution, that may work on some servers is to remove LOCAL like: Original:LOAD DATA LOCAL INFILE New/ It should be: LOAD DATA INFILE Strange, but I have found this solution to work on my local machine, with xampp but it did not work on a live server with CentOS, so I'd to revert the code back and add 'LOCAL'.
のでLOCALを外したら動いた
https://stackoverflow.com/questions/7638090/load-data-local-infile-forbidden-in-php