having problem with "LOAD_FILE("...")" c
Posted 09 April 2003 - 07:50 AM
How to get the LOAD_FILE() command to work in a .php script?
I have tested the command itself in mySQL and it works fine. (I am trying to import a .txt file into one field of a table)
I have used the command as follows :
INSERT INTO common VALUES
(1, 1, LOAD_FILE(\"e:\\1.txt\"), NULL, \'N\');
and it worked the way i wanted it - so there can\'t be any problems with the database itself.
Then I tried to use the same command in a php script :
$address = \"e:\\\\1.txt\";
$load_file = \"INSERT INTO common VALUES
$result = mysql_query($load_file);
then the page containing the script reloads for quite a long time, and when I check mySQL what actually happened I get the output :
WHAT\'S WRONG WITH THE SCRIPT???
the command in mySQL imports the data correctly, the script fails to do so.
Posted 09 April 2003 - 08:40 AM
The problem seems to be too long file names!
I was using names like \"keywords_182398741.txt\"
when I changed the name to \"1.txt\" it worked all right!
Is there any limit to how long a file name can be (for mySQL to handle) ?
Posted 09 April 2003 - 09:11 AM
it\'s the \"_\" in the filename that crashed the whole thing.
could some1 pls reply? I\'m feeling like a loony posting re\'s to my own letter!
Posted 09 April 2003 - 10:10 AM
0 user(s) are reading this topic
0 members, 0 guests, 0 anonymous users