[rt-users] move rt3 to another server

[Clement Twine]

hi Rainer,

>>>> 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.

the other question is, can i instead do a fresh install of rt3.4.2 on
box3 and instruct it to connect and use an existing rt3.0.10 database
on box1?

thanks.
Clem.