[rt-users] Trying top upgrade rt3 3.6.5 database to rt4 4.0.5 database.

[Juanjo]

I read the README file and says:

   1b) Configure the new MySQL to use Latin1 as the default character
       set everywhere, not UTF-8.  This is necessary so the import in
       the next step assumes the data is Latin1.

My Mysql is not full Latin1 to do the upgrade.If you see other emails i
have a lot of problems with the datbase migration.

I only follow the instructions to make the upgrade

Thanks.
Best Regards,

El 22 de marzo de 2012 18:52, Ruslan Zakirov <ruz at bestpractical.com>escribió:

> Hi,
>
> RT uses UTF8. In version prior to RT 3.8 you could have DB configured for
> latin1, but still data is UTF8. This is wrong and upgrade to RT 3.8 or
> newer corrects schema if properly performed.
>
> I don't understand what exactly is your problem.
>
>
> On Fri, Mar 16, 2012 at 17:41, Juanjo <juanjillo at gmail.com> wrote:
>
>> Any help?
>>
>> El 15 de marzo de 2012 09:39, Juanjo <juanjillo at gmail.com> escribió:
>>
>> Hello Again.
>>>
>>> I´m trying to upgrade the old database to my new server database.
>>>
>>> And i have problems with the 1b point.
>>>
>>>    1b) Configure the new MySQL to use Latin1 as the default character
>>>        set everywhere, not UTF-8.  This is necessary so the import in
>>>        the next step assumes the data is Latin1.
>>>
>>> Now i have this
>>>
>>> character set clientutf8 (Valor global)latin1 character set connection
>>> latin1 character set database latin1 character set filesystembinarycharacter set results
>>> utf8 (Valor global)latin1 character set serverlatin1 character set
>>> system utf8
>>> And all the database tables or fields is in utf8_general_ci.
>>>
>>> Could you help me to make this database upgrade?
>>>
>>> Thanks.
>>> Kindest regards.
>>>
>>
>>
>>
>> --
>> Un saludo.
>> Juanjo Corral
>>
>
>
>
> --
> Best regards, Ruslan.
>



-- 
Un saludo.
Juanjo Corral
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.bestpractical.com/pipermail/rt-users/attachments/20120322/7361a293/attachment.htm>