Unable to upload image file in MySQL

Question

I used the following code for uploading an image file into my database from an answer in stack overflow, but it is not getting updated. Please help.

mysql> update S516 set photo = LOAD_FILE('/home/rsreekumar/db/java16/photos/13134.PNG') where roll_no = "AM.EN.U4CSE13134";
Query OK, 0 rows affected (0.00 sec)
Rows matched: 1  Changed: 0  Warnings: 0

My question is same. but not working.

Which answer? what have you tried? What exactly is being expected that is not occuring? — Martin, Jun 23 '16 at 10:03
Possible duplicate of [Load\_File doesn't work](http://stackoverflow.com/questions/8229951/load-file-doesnt-work) — Martin, Jun 23 '16 at 10:05
[This answer](http://stackoverflow.com/a/8230197/3536236) to may well help you — Martin, Jun 23 '16 at 10:05
check the file privileges SELECT user, file_priv FROM mysql.user — JYoThI, Jun 23 '16 at 10:13
If you can't access the user table then that really suggests your issue is you don't have permission to use `LOADFILE`. Take it up with your database provider.... — Martin, Jun 23 '16 at 10:20

Diego Betto · Answer 1 · 2016-06-23T10:43:32.113

0

Can you check?

mysql user has permissions to read file
where condition is correct
column photo is blob
you have permissions to use LOAD_FILE
file size less than max_allowed_packet bytes
if the secure_file_priv system variable is set to a nonempty directory name, the file to be loaded must be located in that directory
is AppArmor protection running (and blocking)?

edited Jun 23 '16 at 10:43

answered Jun 23 '16 at 10:05

Diego Betto

721
6
19

`WHERE` is correct as MySQL statement returns `Rows Martched : 1` – Martin Jun 23 '16 at 10:08
All the privileges are there. Hope it includes reading file. Where condition is correct. Column photo is blob. I don't know how to check the permission to use LOAD_FILE. Please help – Sreekumar R Jun 23 '16 at 10:10
Is permission for LOAD_FILE different from ALL privileges. – Sreekumar R Jun 23 '16 at 10:13
Point 1 is "can /home/rsreekumar/db/java16/photos/13134.PNG be readed by user that executes query?" that is a bit different from "can user execute LOAD_FILE function?" – Diego Betto Jun 23 '16 at 10:26
file exists and is not empty? – Diego Betto Jun 23 '16 at 10:27
File exists. It is in users home directory so readable. Also, asked admin to grant file_priv which she set to 'y'. Still no use. – Sreekumar R Jun 23 '16 at 10:33
does `SELECT LOAD_FILE('/home/rsreekumar/db/java16/photos/13134.PNG');` return anything? – Diego Betto Jun 23 '16 at 10:35
Let us [continue this discussion in chat](http://chat.stackoverflow.com/rooms/115393/discussion-between-diego-betto-and-sreekumar-r). – Diego Betto Jun 23 '16 at 10:38

Unable to upload image file in MySQL

1 Answers1