+- CodeIgniter Forums (https://forum.codeigniter.com)
+-- Forum: Using CodeIgniter (https://forum.codeigniter.com/forumdisplay.php?fid=5)
+--- Forum: General Help (https://forum.codeigniter.com/forumdisplay.php?fid=24)
+--- Thread: Database Error on LOAD DATA INFILE command (/showthread.php?tid=63623)
Database Error on LOAD DATA INFILE command - bazianm - 11-20-2015
I am using:
MySQL 5.5.46-0ubuntu0.14.04.2.
PHP Version 5.5.9-1ubuntu4.14
CI version 3.0.0
I have a controller that accept two files for upload. I am using the file upload class. I have verified that the files are uploaded, placed in the /uploads/ folder and named properly. I checked the case of the file names too.
After the files are uploaded, I copy them to the /tmp/ folder on the server and then send up a LOAD DATA command as follows:
PHP Code:
$lcSQL = "LOAD DATA $local INFILE '$tcFile' " .
"INTO TABLE `$tcTable` " .
"FIELDS TERMINATED BY ',' " .
"LINES TERMINATED BY '\\n' " .
"IGNORE 1 LINES " .
"(field list here, truncated for space) ";
$this->db->query($lcSQL);
The table and file variables are passed through to the controller.
OK, the bottom line is that I am getting a database error that the file I am passing through does not exist. Trouble is, it does. I have visually confirmed this.
Some more details:
1) I set the permissions of the file to 777
2) I checked the case and every character of the file name. It definitely exists.
Any thoughts on this?
Thanks