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!
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
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.
cheers,
Rainer
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),
- upgrade the new copied rt3 db on box2
- and rt should now pick up the imported db and settings on
box2?
thanks
Clem.
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
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.
At Friday 5/20/2005 10:02 AM, Clement Twine wrote:
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?
Afraid not - there are some significant database changes between 3.0 and
3.4. The 3.4 code won’t work with a 3.0 database no matter where it’s located.
Steve
Stephen Turner
Senior Programmer/Analyst - Client Support Services
MIT Information Services and Technology (IS&T)
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
hi Leon,
Leon wrote the following on 05/20/2005 10:09 PM:
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
and this worked beautifully for me, thanks 
huh… how i really love the fact that one cat get a solution to a
problem - just like that!
clem.