I am having a heck of a time with this, I had it working just fine but moved to another server and it is giving me error 13 even with all of the same permissions set.
I was told that I can try to transfer the file to the 'temp' folder and would have a better chance getting it to work.
Can someone please take a look at the code below and let me know how to transfer it to the /temp/ folder and run the file from there.
Here is what my current error is:
Can't get stat of '/var/www/vhosts/server.co
.txt' (Errcode: 13)
The user has 'file' permissions
The current folder and file have 777 permissions
Below is the code I am using.
Thanks for any help.
mysql_query("TRUNCATE TABLE vehicle_data_processing") or die(mysql_error());
$loadsql = 'LOAD DATA INFILE "../../../var/www/vhosts/server.com/httpdocs/processed_files/eiz.txt" INTO TABLE vehicle_data_processing
FIELDS TERMINATED BY "|" LINES TERMINATED BY "\n" IGNORE 1 LINES (dealer_id, company_name, company_address, company_city, company_state, company_zip);';
mysql_query($loadsql) or die(mysql_error());
echo 'Updated the Processing Table<br>';