[rt-users] Problem with graphical attachments after moving database from one server to another

[Jesse Vincent]

On Tue, Nov 29, 2005 at 10:54:37AM +0100, Tomasz Marciniak wrote:
> Hello,
> 
> sorry it it's known and resolved problem - I wasn't able to google it.
> 
> Yesterday I moved my RT database from one server to another. The same 
> version of MySQL (4.1), the same mysqld config. The problem is that 
> now every image attachment is "corrupted" - either it doesn't display 
> at all or it's messed up seriously. Other attachment types (e.g. xls) 
> are all right. The only difference between the two servers is that 
> one is 32-bit Intel, and second is 64-bit AMD. show variables show 
> the same output on both machines - except the 64 bit values for some 
> variables.

My first bet is that your two servers were compiled with different
default charsets and you didn't do a binary dump of your mysql data.

> How can I restore my database to health or what more info should I 
> provide to get some help?
> 
> Thanks in advance.
> 
> Tomasz Marciniak
> _______________________________________________
> http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users
> 
> Be sure to check out the RT Wiki at http://wiki.bestpractical.com
> 
> Download a free sample chapter of RT Essentials from O'Reilly Media at http://rtbook.bestpractical.com
> 
> WE'RE COMING TO YOUR TOWN SOON - RT Training in Amsterdam, Boston and
> San Francisco - Find out more at http://bestpractical.com/services/training.html
> 

--