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, <raym...@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, <raym...@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, <raym...@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
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: sa...@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
_______________________________________________
http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users
Community help: http://wiki.bestpractical.com
Commercial support: sa...@bestpractical.com
Discover RT's hidden secrets with RT Essentials from O'Reilly Media.
Buy a copy at http://rtbook.bestpractical.com