smdlc
02-18-2008, 08:37 AM
I am attempting to load a MySQL table with the command:
LOAD DATA LOCAL INFILE '/filename' INTO TABLE mytable
I have placed the file to be uploaded in my home directory. I am using phpMyAdmin.
Everytime I try to use the command I get an error:
#13 - File '/home/example/file.txt' not found (Errcode: 13)
I think that a #13 error is a permission based error. Do I need to be doing this with SSH/Shell or should it work in phpMyAdmin?
LOAD DATA LOCAL INFILE '/filename' INTO TABLE mytable
I have placed the file to be uploaded in my home directory. I am using phpMyAdmin.
Everytime I try to use the command I get an error:
#13 - File '/home/example/file.txt' not found (Errcode: 13)
I think that a #13 error is a permission based error. Do I need to be doing this with SSH/Shell or should it work in phpMyAdmin?