Insert file into mysql Blob

Question

I try to insert a Open Office document on a blob field. To do this I try

INSERT INTO my_table (stamp, docFile) VALUES (NOW(), LOAD_FILE('/tmp/my_file.odt'));

This works well on windows but on Mac Os the file isn't load on docFile field.

Is anyone has experience about that?

Thanks

Try what is suggested [in this similar question][1] [1]: stackoverflow.com/questions/8229951/load-file-doesnt-work — Yanki Twizzy
– Yanki Twizzy, Commented Feb 2, 2012 at 8:33
As I've done all you suggest, it's why I post. Thanks. If I use tools like phpmyAdmin or Navicate to do the same task, all work well. — Flex60460
– Flex60460, Commented Feb 2, 2012 at 8:49
Do you get any error message, check if u have permission to upload file from that directory — Naveen Kumar
– Naveen Kumar, Commented Feb 2, 2012 at 9:55
I check permission, and all it's good. I use zend and I did 2 tests. The first I place folder and file on webroot, no result, second I place folder and while on mysql root : same result, none. And if I do the same with phpMyAdmin the file is loaded on mysql. — Flex60460
– Flex60460, Commented Feb 2, 2012 at 13:53
Are you using a remote mysql server? The file has to be on the server, not the client. — Barmar
– Barmar, Commented Jul 26, 2012 at 17:02

Kailas · Accepted Answer · 2016-12-20 07:56:13Z

1

File.separator is either / or \ that is used to split up the path to a specific file. For example on Windows it is \ or C:\Documents\Test. But on Mac it is /.

So use File.separator instead of / or \, then it will work for both Mac and Windows.

You can Update the column value having type 'blob'

UPDATE `TableName` SET `ColumnName`=LOAD_FILE('FilePath/FileName.bin') WHERE `YourCondition` 
// FilePath -> C:/foldername/filename.bin

edited Dec 20, 2016 at 7:56

Kailas

3,2415 gold badges48 silver badges54 bronze badges

answered Apr 30, 2015 at 23:17

srikanthvarma

111 bronze badge

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

1 Comment

Ωmega Over a year ago

It doesn't work: 0 row(s) affected Rows matched: 1 Changed: 0 Warnings: 0

Collectives™ on Stack Overflow

Insert file into mysql Blob

1 Answer 1

1 Comment

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Linked

Related