On Wed, Jul 29, 2009 at 9:21 PM, <[email protected]> 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, <[email protected]> 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, <[email protected]> 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 >>>>> >>>>> >>>>> r...@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: [email protected] >>>>> >>>>> >>>>> 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 -- Best regards, Ruslan. _______________________________________________ http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users Community help: http://wiki.bestpractical.com Commercial support: [email protected] Discover RT's hidden secrets with RT Essentials from O'Reilly Media. Buy a copy at http://rtbook.bestpractical.com
