Moving RT (from: debian to: freebsd)

Hello Everyone,

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

Thanks for the advice.

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
NTELOSOn 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:

  1. install and test RT on the target machine

  2. copy the database data using mysqldump to export it to a text file and
    then mysql to import the data on the target machine.

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

You’ll want to read the instructions in the thread that starts at:

http://lists.fsck.com/pipermail/rt-users/2001-February/001649.htmlOn Wed, Apr 04, 2001 at 04:20:59PM -0500, Ashby Gochenour wrote:

Thanks for the advice.

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:

  1. install and test RT on the target machine

  2. copy the database data using mysqldump to export it to a text file and
    then mysql to import the data on the target machine.

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


rt-users mailing list
rt-users@lists.fsck.com
http://lists.fsck.com/mailman/listinfo/rt-users

jesse reed vincent – root@eruditorum.orgjesse@fsck.com
70EBAC90: 2A07 FC22 7DB4 42C1 9D71 0108 41A3 3FB3 70EB AC90

“Mary had a crypto key / She kept it in escrow
And everything that Mary said / The Feds were sure to know” – Sam Simpson