I'm trying to use LOAD DATA to import a csv text file into mysql, via phpmyadmin, however i can't seem to get it to work. Here's my SQL:
LOAD DATA LOCAL INFILE '/home/pearl/public_html/export/pearlexport.txt' INTO TABLE b2bexport_test
I get the following error when trying to run that: #13 - File '/home/pearl/public_html/export/pearlexport.txt' not found (Errcode: 13)
However, if i change the path.. to a broken one, such as /homexxx/ i get this error message: #2 - File '/home/pearlizu/public_html/export/PearlExport.txt' not found (Errcode: 2)
Which makes me think, there's actually a different problem with the first query which returns #13 and it's maybe not a file not found? Can anyone spot anything i'm doing wrong?