Hello,
I try to load a file into the SQL DB, using load_file() function. But this doesn't work.
Database definition:
Field Type Attributes Null Default
ID int(8) No
server_id int(4) Yes NULL
date date Yes NULL
inventtext longblob BINARY Yes NULL
SQLcommand:
mysql> insert into inventory values('', '858', '2008-01-16', LOAD_FILE("/import/tv.20080116"));
The file has the following security settings:
-rwxrwxrwx tv.20080116 (116 KB)
When I execute the command I don't get an error, but are filled like this:
ID server_id date inventtext
242 858 2008-01-16 [BLOB - NULL]
Can anybody tell me what I'm doing wrong.
Thanks in advance
I try to load a file into the SQL DB, using load_file() function. But this doesn't work.
Database definition:
Field Type Attributes Null Default
ID int(8) No
server_id int(4) Yes NULL
date date Yes NULL
inventtext longblob BINARY Yes NULL
SQLcommand:
mysql> insert into inventory values('', '858', '2008-01-16', LOAD_FILE("/import/tv.20080116"));
The file has the following security settings:
-rwxrwxrwx tv.20080116 (116 KB)
When I execute the command I don't get an error, but are filled like this:
ID server_id date inventtext
242 858 2008-01-16 [BLOB - NULL]
Can anybody tell me what I'm doing wrong.
Thanks in advance