Moving rt between machines.]

RT Users
1

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

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

[root@cache /root]# mysql -uroot -ppassword rt2 < rt2.sqldump
ERROR 1062 at line 11: Duplicate entry ‘1’ for key 1
[root@cache /root]# mysql -uroot -ppassword rt2 < rt2.sqlschema
ERROR 1050 at line 11: Table ‘ACL’ already exists
[root@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@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

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.

2

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

[root@cache /root]#mysqlimport -uroot -ppassword rt2 rt2.sqldump
mysqlimport: Error: Table ‘rt2.rt2’ doesn’t exist, when using table: rt2
[root@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@cache /root]# mysql -uroot -ppassword rt2 < rt2.sqldump
ERROR 1062 at line 11: Duplicate entry ‘1’ for key 1
[root@cache /root]# mysql -uroot -ppassword rt2 < rt2.sqlschema
ERROR 1050 at line 11: Table ‘ACL’ already exists
[root@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@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

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

3

Do i make a major mistake if i on the original machine run
mysqldump -uroot -ppassword --opt rt2 > rt2.dump

and on the new machine run :
mysql -uroot -ppassword rt2 < rt2.dump

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@cache /root]# mysql -uroot -ppassword rt2 < rt2.sqldump
ERROR 1062 at line 11: Duplicate entry ‘1’ for key 1
[root@cache /root]# mysql -uroot -ppassword rt2 < rt2.sqlschema
ERROR 1050 at line 11: Table ‘ACL’ already exists
[root@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@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

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

4

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

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

try
mysql -uroot -ppassword rt2 < rt2.sqldump
Providing your base install is there it should work fine. I’ve had to do this
to restore from backup on a number of occasions when users have mangled
tickets out of all recognition…

cheers
john

5

That one did the trick dr john,
but i came up with another problem.

[root@cache /root]# mysql -uroot -ppassword rt2 < rt2.out
ERROR 2006 at line 79: MySQL server has gone away
[root@cache /root]#

so i started the mysqld with some extra parameters…

–set-variable max_allowed_packet=4194304

Believe there was something that was too big in there… the rt2.out
file was 120 MB

But now its up and running!

Thanks to you all!
Specially Alesh Mustar for his patience! :wink:

Tore

dr john halewood wrote:>On Tuesday 20 November 2001 11:53, Tore Micaelsen wrote:

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

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

try
mysql -uroot -ppassword rt2 < rt2.sqldump
Providing your base install is there it should work fine. I’ve had to do this
to restore from backup on a number of occasions when users have mangled
tickets out of all recognition…

cheers
john

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.