I need to move RT (version 1.0.1) from a debian linux (2.2 potato) machine
to a freebsd (4.2 stable) machine.
I want to make sure I don’t lose the data that is associated with the
system as it contains several thousand tickets.
I do not know much SQL (I’ve never accessed RT via SQL) and I’m not real
clear on the inner workings of RT (i.e- I don’t even know where on the
system the database resides).
I was wondering what the best way to make this move would be. Should I
install RT on the freebsd machine and then move the data over, or is there
some kind of documentation/guide that can take me through this process?
Thank you for any advice,
Ashby Gochenour
Unix Systems Administration
NTELOS
I have a couple questions about the ‘database’. When you say to use
mysqldump to copy the database, do you mean the transactions directory or
is there another database that I need to copy?
Do you know what sql commands would be used to import the database?
I have another question. When I install RT, should I stick with 1.0.1 or
shouuld I put another version of 1.0.x on instead ?
I have a couple questions about the ‘database’. When you say to use
mysqldump to copy the database, do you mean the transactions directory or
is there another database that I need to copy?
Do you know what sql commands would be used to import the database?
I have another question. When I install RT, should I stick with 1.0.1 or
shouuld I put another version of 1.0.x on instead ?
Thanks again,
Ashby Gochenour
Unix Administration
NTELOS
On Wed, 4 Apr 2001, Bertrand Delacretaz wrote:
Should I install RT on the freebsd machine and then move the data over
That’s what I would do. As far as I know, you need to:
install and test RT on the target machine
copy the database data using mysqldump to export it to a text file and
then mysql to import the data on the target machine.
copy the contents of the “transactions” directory over, usually/
var/rt/transactions for a standard RT install.
Hope this helps!
– Bertrand Delacrétaz, www.codeconsult.ch
– web technologies consultant - OO, Java, XML, C++