[rt-users] move rt3 to another server

[Rainer Duffner]

Clement Twine wrote:

> Rainer Duffner wrote the following on 05/20/2005 10:40 AM:
>
>> Clement Twine wrote:
>>
>>> Hi RT Users,
>>>
>>> I have tried to search WiKI but cannot find answer to my
>>> question. I apologize if i did not search well, yet i suspect
>>> someone has encountered my situation too!
>>>
>>> I have an RT3.0.10 install working on one box (box1), with over
>>> 3000 tickets. I have another fresh RT 3.4.1 install working on
>>> another box (box2).
>>>
>>> I would like to move the rt3 database from box1 to box2, so that
>>> box2 continues over what box1 was doing.
>>>
>>> What i did was copy the rt3 database under mysql from box1 to
>>> box2, but this did not work!
>>
>>
>> Of course not. You must first upgrade the database. Read the
>> update-instructions that are located inside the tar.gz. I'd
>> reproduce the first install on the 2nd machine and then upgrade that, 
>> when it works.
>
>
> so, should i:
>
> - copy the rt3 db from /var/lib/mysql/rt3 box1 (rt 3.0.10) to
>   /var/lib/mysql/rt3 box2 (3.4.1),


If it is the same (major) version of mysql this could work.
Beware of acls. You could seriously damage your db.

> - upgrade the new copied rt3 db on box2
> - and rt should now pick up the imported db and settings on
>   box2?



Note that you cannot run the webinterface until the db is updated.



Rainer