• 0 Vote(s) - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
Database Error on LOAD DATA INFILE command

#1
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
Reply


Digg   Delicious   Reddit   Facebook   Twitter   StumbleUpon  


  Theme © 2014 iAndrew  
Powered By MyBB, © 2002-2020 MyBB Group.