Update mysql XML blob

Question

I am working on a Windows 7 machine and need to update a mySql row on an Ubuntu server. I open Workbench and run "show grants;" and it returns with GRANT ALL

I have a column in the database that shows as xml in the Workbench viewer when I run:select UNCOMPRESS(data) from database.detail where file_id = 57;

I need to update that row, I tried to save the blob as xml on disk and run: select LOAD_FILE('C:\Trash\544357.xml'); but that returns nothing so: UPDATE database.detail SET data = LOAD_FILE("C:\Trash\544357.xml") where file_id = 57; does not work either.

did you try ``\\``? `C:\Trash` will probably just be parsed as `C:Trash` by MySQL, since \T isn't a valid metachar escape — Marc B, Sep 25 '14 at 21:30

score 0 · Answer 1 · edited May 23 '17 at 12:13

0

Rack on up for not reading some of the answers I found on Google!! This LINK explained that the file must be on the server. I moved the file from my local windows 7 machine to the Ubuntu mysql box tmp folder and ran: UPDATE database.detail SET data = LOAD_FILE("/tmp/544357.xml") where file_id = 57

DONE!!!

edited May 23 '17 at 12:13

Community

1
1

answered Sep 26 '14 at 15:52

Jack Smit

3,093
4
30
45

Update mysql XML blob

1 Answers1