[rt-users] 3.6.0rc3/mysql: reinserting image attachments into the DB?

Ole Craig ocraig at stillsecure.com
Tue Jun 6 21:50:45 EDT 2006


Background: Startups being what they are, I had to shove my RT
installation out the aircraft door long before I felt ready, hoping the
chute was in working order... I don't currently have hardware for a test
system; when I have to tweak RT, I'm sometimes forced to do a mysqldump
and then restore from the dump after testing changes. After one such
dump/change/test/restore sequence, I noticed that any images attached to
existing tickets had been corrupted, probably because before today I'd
not thought to specify the "-O --hex-blob=TRUE" option to mysqldump. If
you're curious as to what happened to the images, a sample
before-and-after: 
http://www.cs.umass.edu/~olc/original-email-image.jpg
http://www.cs.umass.edu/~olc/corrupted-RT-image.jpg

(latter image has been GIMPed to obfuscate of innocent bystanders and
their support requests, ignore the black blotches. It's the psychedelia
that's the problem.)

My question: I still have all the emails from which those image
attachments were culled. Does anyone have a suggestion for how to
reinsert the uncorrupted images into the database in place of the
useless blobs currently residing there? (I'm no DBA at the best of
times, and I've never needed to work with non-textual data in mysql
before; I'm feeling a bit lost...)

	Thanks,
		Ole

-- 
/Ole Craig
Security Engineer

303-381-3802 (main support hotline)
303-381-3824 (my direct line)
303-381-3801 (fax)

www.stillsecure.com
. . .



More information about the rt-users mailing list