Moving rt between machines

Hi there!

Have a rt-2.0.4 on one machine, with about 5000 tickets, want to move
this over to another machine.
So i have prepared an rt-2.0.9 (to upgrade too).
What is the best way for moving the tickets and data over?

Was a nice job when i upgraded from rt-1 to rt-2, with the import script.
Can i use the same when i move an upgrade within version 2 ?

Best Regards
Tore

Secure your mail with MultiNet AS - www.multinet.no
This mail has been scanned for viruses by moya.multinet.no
using AmaVis-Perl-11 with the following virus engines:
Kaspersky Labs, F-Secure, Sophos and Innoculate with
virus signaturefiles checked and updated every hour.

Tore,

the easiest way would be to simply do a dump of RT mysql files:
mysqldump -c -t -uroot -ppassword rt2 > rt2.sqldump
mysqldump -d -uroot -ppassword rt2 > rt2.sqlschema

replace password with your mysql root password ofcourse.

You can then simply import this into mysql on your new machine.

I use the same set of commands to make nightly backup of RT via crontab.

Regards,
Alesh

Tore Micaelsen wrote:

Or if you’re using postgres,
$ pg_dump -a -f rt2.sqldump rt2
This dumps the data without the schema, assuming you’ll be doing a new RT install.
Drop the -a flag to dump with schema, or use -s to dump schema only.

Then on the new machine do:
$ pg_restore rt2.sqldump

-Feargal.On Tue, 20 Nov 2001 10:04:14 +0100, Alesh Mustar alesh@sportina.si wrote:

Tore,

the easiest way would be to simply do a dump of RT mysql files:
mysqldump -c -t -uroot -ppassword rt2 > rt2.sqldump
mysqldump -d -uroot -ppassword rt2 > rt2.sqlschema

replace password with your mysql root password ofcourse.

You can then simply import this into mysql on your new machine.

I use the same set of commands to make nightly backup of RT via crontab.

Regards,
Alesh

Tore Micaelsen wrote:

Hi there!

Have a rt-2.0.4 on one machine, with about 5000 tickets, want to move
this over to another machine.
So i have prepared an rt-2.0.9 (to upgrade too).
What is the best way for moving the tickets and data over?

Was a nice job when i upgraded from rt-1 to rt-2, with the import script.
Can i use the same when i move an upgrade within version 2 ?

Best Regards
Tore


Secure your mail with MultiNet AS - www.multinet.no

This mail has been scanned for viruses by moya.multinet.no using
AmaVis-Perl-11 with the following virus engines:
Kaspersky Labs, F-Secure, Sophos and Innoculate with
virus signaturefiles checked and updated every hour.


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


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

Feargal Reilly, | Communications House,
Systems Administrator. | 1a Lower Pembroke Street,
The CIA - http://www.thecia.ie/ | Dublin 2,
Ph: +353-1-6768230 Fax: +353-1-6767720 | Ireland.

PGP fingerprint: 9EA0 F62E 2345 6062 E522 00F2 31D0 B1B0 D678 96DB