[rt-users] Mysqldump 3.6.3 -> 3.6.5 ( attachments )

[Roy Sowa]

I am in the process of moving my existing RedHat 3.6.3 install to a SUSE 10 3.6.5 box ...
I thought all was going well, but I just stumbled into a problem...

I had been using  the following mysqldump ;
mysqldump --opt --add-drop-table --single-transaction ........ rt3 > backup.out

and this restores nicely.. ( I thought I was good to go ). 
the records look correct and I see the attachment links in the tickets that have them, But
now when I try and view an attachment  by clicking on the link  it says "page not found"....
the url link matches the search format of that of the original working server ...

what I have tried so far...

A few searches surfaced that I might try adding this to my dump statement "--default-character-set=binary"

but this did not change things...

Trying to create a new ticket with a simple attachment also does not work....
Funny enough If I attach a simple gif, I see the gif in the newly created ticket, however I just cannot click on the download link in the transaction  or the link in the attachment area... ( page not found...)

So then I found this snippet  RE: binary attachment corruption; 

Hello, Chris. 
Could you backup your DB, and run next to SQL queries? 
ALTER TABLE Attachments CHANGE Content Content LONGBLOB NULL; 
Then check if you could binary attachments without problems and report back. 
This query is safe but anyway I would suggest you to backup data. .....


This did not change results either...

I really would like to convert  to the newer server/hardware.... 

any suggestions as to where I went wrong or how to move this forward ???