[rt-users] move rt3 to another server

[Ruslan U. Zakirov]

Rainer Duffner wrote:
> 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.
This wouldn't work because RT uses InnoDB engine. You should use 
mysqldump util I think.

> 
>> - 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
> _______________________________________________
> http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users
> 
> Be sure to check out the RT Wiki at http://wiki.bestpractical.com
>