LOAD DATA LOCAL INFILE - File not found


#21

It could be a problem generated by the fact that we have no root access on free hosting plan.


#22

Anyone know if this was sorted out? Sorry for dragging up an old thread, but I’m looking at doing similar to the OP where I want to import a CSV programatically…

thanks.


#23

Does it throw an error for you?


#24

Hi @mrots!

You will not be able to import CVS files unless you upload them somehow directly to import in phpmyadmin. The manual “retrieve from server” does not work because of how system is built.

It might work though on a paid plan or on a VPS :wink:


#25

@ckhawand,

I get the file not found, or access denied errors depending on how I’m trying to get it to work at the time…

I found the environment path as suggested by @infinity above, but no luck…

Where exactly can I put a CSV to be able to access it with LOAD DATA on your servers?

Thanks.