MySQL Forums
Forum List  »  PHP

Re: LOAD DATA not finding file
Posted by: Menachem Bazian
Date: November 20, 2015 07:46AM

OK, some more information.

1) I developed this on a windows box. It works on the windows box.
2) I put it on an Ubuntu 14.04 server and that's where the errors happen.
3) When I ran it in MySQL command line, it worked fine.
4) I tried running the command from MySQL Workbench (from the windows machine connected to the ubuntu machine) and got the error.

5) I changed the folder to just 'upload/' and get the following error:

Can't get stat of '/var/lib/mysql/uploads/5a13da19-594b-43bf-b78d-4f29ace0fb3d_PSExtract.csv' (Errcode: 2)

I should say I am using CodeIgniter as my php framework... Not sure if that makes a difference but...

Thanks for all your help.

Options: ReplyQuote


Subject
Written By
Posted
November 19, 2015 02:50PM
November 19, 2015 05:11PM
November 19, 2015 10:15PM
Re: LOAD DATA not finding file
November 20, 2015 07:46AM
November 21, 2015 03:56AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.