[rt-users] moving rt between machines.

[Feargal Reilly]

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 at 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 at lists.fsck.com
> > http://lists.fsck.com/mailman/listinfo/rt-users
> > 
> 
> 
> 
> _______________________________________________
> rt-users mailing list
> rt-users at 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