[rt-users] moving rt between machines.]

[Tore Micaelsen]

So i dont mess up completly, how is the import command?

because this is what i tried to import to the new base

[root at cache /root]# mysql -uroot -ppassword rt2 < rt2.sqldump
ERROR 1062 at line 11: Duplicate entry '1' for key 1
[root at cache /root]# mysql -uroot -ppassword rt2 < rt2.sqlschema
ERROR 1050 at line 11: Table 'ACL' already exists
[root at cache /root]#



Best Regards
Tore


Alesh Mustar 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
>
>
> ----------------------------------------------------------
>   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.
>
>
>
>
>





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