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?
I am exporting rt 3.2.2 db on old server and importing to the new server
running rt 3.8.4
mysql -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
_______________________________________________
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
