[rt-users] Pg to mysql : attachements not viewable

[Kristian Davies]

On Mon, Jun 6, 2011 at 3:49 PM, Kevin Falcone <falcone at bestpractical.com> wrote:
>> Just in case it's something to do with database encoding, I used
>> rt-3.8.2/etc/schema.mysql to create the database (and
>> rt3-on-pg-to-mysql script from the wiki?? to import from pg).
>
> That's the wrong schema, you wanted schema.mysql-4.1
> Any new attachments are likely to have corruption.
>
> I know nothing about the script you're using, but you have to convert
> out of the base64 storage used on Pg to binary storage on mysql.
> Your content-type headers imply that you didn't do that.

Performed a backup (data only), dropped database, created schema.mysql-4.1
schema and used suggestions in upgrade-mysql-schema.pl,
imported data.

I only lost 5 attachments, which I've requested be uploaded again, phew.....

Thanks,
Kristian