[rt-users] move rt3 to another server

[Leon]

I actually went down this path recently.  I had RT 3.0.6 running on a RH8
box.  I needed to move it to a faster system.  The current version, at the
time was 3.2.2  Ruslin is right.  Use sqldump.  Its real straight forward.
The thing is that versions need to be the same AND nothing(!) on the new
system will be preserved.
  So you either have to
--upgrade the old system (box1)3.4.1
--use sqldump
--import your data on box2 using the sql command
or
--reinstall 3.0.10 on the new system(box2)
--use sqldump on box1
--import your data(the sqldump file) on box2 using the sql command
--upgrade RT on box2 to 3.4.1 (as per migration instructions in distro)

I actually did the later. And other than a vague instruction (which I was
able to clairfy) the transistion went perfect.  Hope this helps.

-----Original Message-----


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!

is there another clean way to do this? The rt3 db is under
/var/lib/mysql on box1 which runs redhat.

please advise

thanks
Clem
_______________________________________________
http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users

Be sure to check out the RT Wiki at http://wiki.bestpractical.com