Path syntax for LOAD_FILE using WAMP server

Question

I am using a local database and I am trying to insert a image into a Photo VARBINARY(20000) column.

What is the path I have to use to LOAD_FILE?

INSERT INTO ImageTable(PHOTO) VALUES(LOAD_FILE('E:/wamp64/bin/mysql/mysql5.7.14/data/test.jpg'));

Is what I am using. This enter NULL into the table. MySQL is also under this path. Does the path have to be relative to something? I am using the command line.

Dont' save files in a database. stackoverflow.com/a/41235395/267540 — e4c5
– e4c5, Commented Jan 7, 2017 at 12:23
do you get an error that the file was found or not? If not, then MySQL interprets the file correctly, then you have to look at the file contents. — davejal
– davejal, Commented Jan 7, 2017 at 12:27
i tried loading a file that is non-existent and it doesnt give any error anyways. @e4c5: I have the string too that I can data:image/jpeg;base64 but it is too long to insert using the command line. Any tips on that? — sandboxj
– sandboxj, Commented Jan 7, 2017 at 12:28
Ok so basically the answer tells me not to do it. But it is sort of a requirement for the app I m working on. I need to insert either the image or the string. — sandboxj
– sandboxj, Commented Jan 7, 2017 at 12:32

score 1 · Accepted Answer · 2017-01-07 12:33:50Z

1

Actually if you're using image, Varchar is not the right type. You should use BLOB instead. This should cover it:

INSERT INTO ImageTable(PHOTO) VALUES(1,LOAD_FILE('E:/wamp64/bin/mysql/mysql5.7.14/data/test.jpg'));

Search further for BLOB and LONG BLOB to use images.

edited Jan 7, 2017 at 12:33

answered Jan 7, 2017 at 12:30

user7362545

Sign up to request clarification or add additional context in comments.

4 Comments

sandboxj Over a year ago

Sorry, my mistake. It is of type VARBINARY(20000), not VARCHAR. :( I corrected it in the main post.

user7362545 Over a year ago

Anyway the code i wrote should help. I had the same problem once, only that I was using varchar to find the image path. Intead, BLOB will load the image on the link you insert. :)

sandboxj Over a year ago

Unfortunately, I am working on an existing database and am not supposed to change the column types. But using the absolute path is correct or, this is not a pathing issue?

user7362545 Over a year ago

Not a pathing issue. If the absolute path leads to an image, should work.

sandboxj · Accepted Answer · 2017-01-07 14:49:07Z

0

I disabled --secure-file-priv and it worked. But unsure whether that was the problem because the error message for taht was not shown.

answered Jan 7, 2017 at 14:49

sandboxj

1,2644 gold badges24 silver badges49 bronze badges

Collectives™ on Stack Overflow

Path syntax for LOAD_FILE using WAMP server

2 Answers 2

4 Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

4 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related