[rt-users] RT Migration

[alesh at opensource-technologies.com]

A simple dump and import of the data will do:

/usr/local/mysql/bin/mysqldump -c -t -uroot -p<password> rt2 >
rt2.sqldump
/usr/local/mysql/bin/mysqldump -d -uroot -p<password> rt2 >
rt2.sqlschema

Replace the above path to mysqldump according to your path.

Then do:
mysql -uroot -p < rt2.sqldump

After you have installed RT!

Regards,
Ales
--
Ales Mustar
direktor
Opensource-Technologies
Ales Mustar s.p.


On Fri, 10 May 2002, Mark Hodge wrote:

> Date: Fri, 10 May 2002 10:57:44 +0100
> From: Mark Hodge <Mark.Hodge at csf.co.uk>
> To: "'rt-users at lists.fsck.com'" <rt-users at lists.fsck.com>
> Subject: [rt-users] RT Migration
>
> I am migrating a RT environment onto a more powerful machine, and taking the
> opportunity to upgrade the OS and RT version.  Is there an may of moving the
> historical data, queues, users etc.  It is an mysql database on both
> servers.
>
> 	Thanx
>
> 		Mark
>
>
> Mark J Hodge
> mark.hodge at csf.co.uk
> SP Program Manager 						Tel: +44
> (0)870 7499292
> CSF Solutions Ltd. 						Fax: +44
> (0)870 7499290
>
>
>
> This e-mail including any attachments is confidential and may be
> legally privileged. If you have received it in error please advise the
> sender immediately by return email and then delete it from your
> system.
> All electronic communications with the Company may be monitored
> in accordance with the UK Regulation of Investigatory Powers Act,
> Lawful Business Practice Regulations, 2000.
> If you do not consent to such monitoring, you should contact
> the sender of the e-mail.
> The unauthorised use, distribution, copying or alteration of this
> email is strictly forbidden. If you need assistance please contact
> Head Office on (+44)(0)870 749 9000 between 9:00 am and 5:30 pm GMT
>
> _______________________________________________
> rt-users mailing list
> rt-users at lists.fsck.com
> http://lists.fsck.com/mailman/listinfo/rt-users
>
> Have you read the FAQ? The RT FAQ Manager lives at http://fsck.com/rtfm
>