[rt-users] Migration to RT 4.0.17 from 3.8.9 with new server

[Asif Iqbal]

On Tue, Aug 13, 2013 at 1:40 PM, Lois Bennett <
lois.bennett at channing.harvard.edu> wrote:

> Hello,
>
> I have read the documentation on upgrading and  none of the particulars
> exactly fit.
>
> I have a new VM (Centos6).  I have installed RT 4.0.17 completely vanilla.
>
>
> Old mysql:
> mysql  Ver 14.12 Distrib 5.0.81, for unknown-linux-gnu (x86_64) using
> readline 5.2
> Old RT is  3.8.9
>
> New mysql:
> mysql  Ver 14.14 Distrib 5.1.66, for redhat-linux-gnu (x86_64) using
> readline 5.1
>
> All has gone well.
>
> I have gotten  as far as running make initialize-database.
>
> Now what?  I am not clear if the next step is to take a dump of the
> running server and copy it to the new server then run update database?
>
>
This is what I did as next steps

- copy over the RT_SiteConfig.pm from /opt/rt3/etc to /opt/rt4/etc
- comment out the plugins
- mysql> drop database rt4;
- mysql> create database rt4;
- # mysql < dump.from.rt3.sql
- src/rt-4.0.17# sudo make upgrade-database
- uncomment the plugins from RT_SiteConfig.pm
- .. follow the rest of the steps from README ..


Do I need to do anything to the database before I use it?
>
> I see  someone else doing this:
> >     1. make a clone of the existing RT,
> >     2. upgrade it to 4.0.13
> >     3. do a mysqldump on the upgraded clone
> >     4. restore the dump on the new server.
>
> Is it recommended to actually clone the old and upgrade it in place?
> Could I simply restore a backup from the old on the new and run
>   make upgrade-database
>
> I know I will need to setup users, groups, cron, email and probably some
> other things as well.
>
> T
> hank you for your help.
>
> Peace,
> Lois
>
>
> --
> Lois Bennett, MSEE
> Senior System Administrator
> Channing Laboratory
> Brigham & Women's Hospital
> A Teaching Affiliate of
> Harvard Medical School and
> Harvard School of Public Health
>



-- 
Asif Iqbal
PGP Key: 0xE62693C5 KeyServer: pgp.mit.edu
A: Because it messes up the order in which people normally read text.
Q: Why is top-posting such a bad thing?
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.bestpractical.com/pipermail/rt-users/attachments/20130813/c4db15f1/attachment.htm>