How to use LOAD_FILE to load a file into a MySQL blob?

by

The manual states the following:

LOAD_FILE(file_name)

Reads the file and returns the file contents as a string. To use this
function, the file must be located on the server host, you must
specify the full path name to the file, and you must have the FILE
privilege. The file must be readable by all and its 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.

If the file does not exist or cannot be read because one of the
preceding conditions is not satisfied, the function returns NULL.

As of MySQL 5.0.19, the character_set_filesystem system variable
controls interpretation of file names that are given as literal
strings.

mysql> UPDATE t
            SET blob_col=LOAD_FILE('/tmp/picture')
            WHERE id=1;

From this, I see more than one thing that could be wrong in your case…

  • are you passing the full path?
  • are privileges set correctly?
  • what does the function return? NULL?
  • have you tried it with the query given in the manual?

More Related Contents:

  1. Should I use the datetime or timestamp data type in MySQL?
  2. Delete all Duplicate Rows except for One in MySQL? [duplicate]
  3. Compare two MySQL databases [closed]
  4. MySQL – Trigger for updating same table after insert
  5. How do I get the current time zone of MySQL?
  6. How to get the difference in years from two different dates?
  7. Mysql: Setup the format of DATETIME to ‘DD-MM-YYYY HH:MM:SS’ when creating a table
  8. How to store a datetime in MySQL with timezone info
  9. MySQL utf8mb4, Errors when saving Emojis
  10. How to store unicode in MySQL?
  11. mysql after insert trigger which updates another table’s column
  12. How to create linked server MySQL
  13. Error Code: 1406. Data too long for column – MySQL
  14. Search for string within text column in MySQL
  15. How to export a mysql database using Command Prompt?
  16. How to pass parameters to mysql query callback in nodejs
  17. MySQL Incorrect datetime value: ‘0000-00-00 00:00:00’
  18. Clear MySQL query cache without restarting server
  19. Checking a table for time overlap?
  20. Does mysql have the equivalent of Oracle’s “analytic functions”?
  21. How to change MySQL table names in Linux server to be case insensitive?
  22. Mysql insert into 2 tables
  23. MySQL UPDATE and SELECT in one pass
  24. where does MySQL store database files?
  25. MySQL: How to retrieve a random row or multiple random rows?
  26. MySQL vs. JSON – Why? [closed]
  27. Should I always prefer MySQL InnoDB over MyISAM?
  28. MySQL add 12 hours to a time field
  29. OSX ld: library not found for -lssl
  30. MySQL: Find Missing Dates Between a Date Range

Leave a Comment