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

[raymond at pilotsupplies.com]

Hi,

Ok. thanx!


raymond


On Sat, 1 Aug 2009, Ruslan Zakirov wrote:

> I didn't know you have mysql 4.0, on this version there is no such
> option. So your dmp is correct.
>
> On Sat, Aug 1, 2009 at 2:13 AM, <raymond at pilotsupplies.com> wrote:
>>
>> Hi Ruslan,
>>
>> I finally got some time to export old server DB per your instruction using
>> binary set -
>>
>> mysqldump --opt --add-drop-table --single-transaction
>> --default-character-set=binary -u root -pXXXXXX -h localhost rt3 | gzip -c >
>> /var/www/db_bkp/RTNEW-RT3-$date.sql.gz
>>
>>
>> and got the following errors? How to fix?
>>
>> server is running mysql 4.022 on debian
>>
>>
>> ester:/var/dba/scripts# mysqldump: Character set 'binary' is not a compiled
>> character set and is not specified in the '/usr/share/mysql/charsets/Index'
>> file
>>
>>
>>
>> [1]+  Done                    ./backup_mysql.new
>>
>>
>>
>>
>>
>>
>>
>> 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
>
>
>
>

-- 



Regards,

Raymond Wong


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