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

[Ruslan Zakirov]

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



-- 
Best regards, Ruslan.