[rt-users] Table 'rt3.ObjectCustomFields' doesn't exist

[raymond at pilotsupplies.com]

Hi,

I tried without  --default-charset=binary on export of old 
DB 3.2.2 and import into 3.8.4 on new server  and I 
can see old attachments and new attachments on new server without any 
issues. Don't know if this 
will be an issue in the future.


old serve is running mysql 4.0.22

new server is running mysql 5.0.75-0ubuntu10.2



raymond





On Wed, 29 Jul 2009, Ruslan Zakirov wrote:

> On Wed, Jul 29, 2009 at 9:21 PM, <raymond at pilotsupplies.com> wrote:
>> Hi,
>>
>> Thank you for the suggestion.
>>
>> I'll give that a shot. This is a migration from an old box running 3.2.2 to
>> a  new server which is rt 3.8.4 fresh install.  Will I need to do "make
>> upgrade" as indicated in the 3.8.4 README file?
>
> Nope, you run `make install` instead of `make upgrade` as you have no
> RT files on new server.
>
>> I am exporting rt 3.2.2 db on old server and importing to the new server
>> running rt 3.8.4
>
> Don't forget to using --default-charset=binary, both on export and
> import. Check exact syntax in mysql's docs. It's important or you can
> break every binary attachment.
>
>>
>>
>> mysql -u root -p rt3 < oldrt3.2.2.db.sql
>
> mysql --default-charset=binary -u root -p rt3 < oldrt3.2.2.db.sql
>>
>>
>>
>> raymond
>>
>>
>>
>>
>>
>> On Wed, 29 Jul 2009, Ruslan Zakirov wrote:
>>
>>> Then you missed one step. You have to upgrade DB first from 3.2.2 to
>>> 3.7.89 first. It's `rt-setup-database --action update ...` command
>>> described in more details in UPGRADING.mysql and README files.
>>>
>>> On Tue, Jul 28, 2009 at 11:39 PM, <raymond at pilotsupplies.com> wrote:
>>>>
>>>> Hi Ruslan,
>>>>
>>>>
>>>> My apologies.  I was upgrading from 3.2.2
>>>>
>>>>
>>>> raymond
>>>>
>>>>
>>>>
>>>> On Tue, 28 Jul 2009, Ruslan Zakirov wrote:
>>>>
>>>>> Why do you even need mysqlupgrade.sql if it's fresh install?
>>>>>
>>>>> On Tue, Jul 28, 2009 at 10:13 PM, <raymond at pilotsupplies.com> wrote:
>>>>>>
>>>>>> ubuntu vmware esx4i with ubuntu 9.04 4GB of memory dual xeon processor
>>>>>>
>>>>>> fresh 3.8.4 install, apache2, perl_Mode 2, mysql 5
>>>>>>
>>>>>> go error "Table 'rt3.ObjectCustomFields' doesn't exist"
>>>>>>
>>>>>> so I went and commented out the following, see below and proceed with
>>>>>> the
>>>>>> install with no other issues.
>>>>>>
>>>>>> Am wondering if there are any implications, issues or problems with
>>>>>> this
>>>>>> or is there a better way to fix this ?
>>>>>>
>>>>>>
>>>>>> thanx!
>>>>>>
>>>>>>
>>>>>>
>>>>>> /usr/local/src/rt-3.8.4/etc/upgrade# mysql -u root -p rt3 <
>>>>>> mysqlupgrade.sql
>>>>>> Enter password:
>>>>>> ERROR 1146 (42S02) at line 77: Table 'rt3.ObjectCustomFields' doesn't
>>>>>> exist
>>>>>>
>>>>>>
>>>>>> root at joeblow:/usr/local/src/rt-3.8.4/etc/upgrade# vi mysqlupgrade.sql
>>>>>>
>>>>>> #ALTER TABLE ObjectCustomFields
>>>>>> #   DEFAULT CHARACTER SET utf8;
>>>>>> #ALTER TABLE ObjectCustomFieldValues
>>>>>> #   DEFAULT CHARACTER SET utf8;
>>>>>>
>>>>>>
>>>>>>
>>>>>> --
>>>>>>
>>>>>>
>>>>>>
>>>>>> Regards,
>>>>>>
>>>>>> Raymond Wong
>>>>>>
>>>>>>
>>>>>> Personal motto: P.E.A.C.E
>>>>>> Enjoy the present
>>>>>> Assert your goals
>>>>>> Champion peace
>>>>>> Entrust others
>>>>>> _______________________________________________
>>>>>> http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users
>>>>>>
>>>>>> Community help: http://wiki.bestpractical.com
>>>>>> Commercial support: sales at bestpractical.com
>>>>>>
>>>>>>
>>>>>> Discover RT's hidden secrets with RT Essentials from O'Reilly Media.
>>>>>> Buy a copy at http://rtbook.bestpractical.com
>>>>>>
>>>>>
>>>>>
>>>>>
>>>>>
>>>>
>>>> --
>>>>
>>>>
>>>>
>>>> Regards,
>>>>
>>>> Raymond Wong
>>>>
>>>>
>>>> Personal motto: P.E.A.C.E
>>>> Enjoy the present
>>>> Assert your goals
>>>> Champion peace
>>>> Entrust others
>>>
>>>
>>>
>>>
>>
>> --
>>
>>
>>
>> Regards,
>>
>> Raymond Wong
>>
>>
>> Personal motto: P.E.A.C.E
>> Enjoy the present
>> Assert your goals
>> Champion peace
>> Entrust others
>
>
>
>

-- 



Regards,

Raymond Wong


Personal motto: P.E.A.C.E
Enjoy the present
Assert your goals
Champion peace
Entrust others