LOAD DATA LOCAL INFILE - File not found

Community support
#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:

1 Like
#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.