[rt-users] moving rt between machines.]

[Tore Micaelsen]

Am trying, but looks like i cant figue out the syntax...
trying

[root at cache /root]#mysqlimport -uroot -ppassword rt2 rt2.sqldump
mysqlimport: Error: Table 'rt2.rt2' doesn't exist, when using table: rt2
[root at cache /root]#


should i drop the base first? because the fresh install i did created an 
rt2 base..?

Best Regards
Tore



Alesh Mustar wrote:

> Use mysqlimport.
>
> A.
>
> Tore Micaelsen wrote:
>
>>
>>
>>
>> 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.
>>
>>
>>
>>
>> _______________________________________________
>> 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.