Backup and restore RT3

RT Users
1

Hi !

I’m migrating RT machine to new one.
After backup as below,
/usr/local/bin/mysqldump --user=root --password=xxx rt3 > ./backup.sql

I tried to restore on new machine as below,
/usr/local/bin/mysql --user=root --password=xxx rt3 < ./backup.sql

But I got following error message instead of restoring.
“ERROR 1050 at line 11: Table ‘ACL’ already exists”

Do you have any good idea ?
Is there any recommendation for that kind of job ?

Thanks

Regards,
Han

2

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

Hi Han,

see man mysqldump (–add-drop-table).

I don’t know if the whole procedure is right to backup RT, but at least
the thing above will stop the

“ERROR 1050 at line 11: Table ‘ACL’ already exists”

messages.

Regards,

Benne

Am Donnerstag, 20.11.03, um 06:57 Uhr (Europe/Paris) schrieb Hangu
Jeong:

Hi !

I’m migrating RT machine to new one.
After backup as below,
/usr/local/bin/mysqldump --user=root --password=xxx rt3 > ./backup.sql

I tried to restore on new machine as below,
/usr/local/bin/mysql --user=root --password=xxx rt3 < ./backup.sql

But I got following error message instead of restoring.
“ERROR 1050 at line 11: Table ‘ACL’ already exists”

Do you have any good idea ?
Is there any recommendation for that kind of job ?

Thanks

Regards,
Han

rt-users mailing list
rt-users@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

Benjamin Boksa

b.boksa@sidebysite.de
PGP: http://www.sidebysite.de/pgp/b.boksa.asc

side by site GmbH & Co. KG
Druckgestaltung & Webdesign

Barbarastr. 3-9 (Block 6)
D-50735 Koeln

Fon: +49 221 2790964
Fax: +49 221 2790965

-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.2.3 (Darwin)

iD8DBQE/vGIVR5U9XkJXZKwRAtgoAJkBgrsOC0YLupOWwop9ea0Yttp9wACfUmor
IRoT3DGmQ18BoZCiQ3dj8lI=
=M9hk
-----END PGP SIGNATURE-----

3

We use the following command for our RT systems

/usr/local/bin/mysqldump --tab=/usr/local/dbbkup --opt rt3 -u XXXX
–password=XXXX

This dumps .sql and .txt files. The .sql is of course the structure of the
database but the .txt files are the data per table. The .txt is handy if you
just want to reload certain or even all the data. You can even make it much
easier to import it if you want by using phpmysql.

Richie Crews
Team Lead of Unix Systems and Technologies
Red Hat Certified Engineer
Email: rcrews@intercall.com
Cell: (706) 773 - 3436
Desk: (706) 634 - 3681
Fax: (706) 634 - 3831

“Providing security for your email needs”
Stop Spam, Support RBL http://www.mail-abuse.org-----Original Message-----
From: Hangu Jeong [mailto:hgjeong@icraft21.com]
Sent: Thursday, November 20, 2003 12:57 AM
To: rt-users@lists.fsck.com
Subject: [rt-users] Backup and restore RT3.

Hi !

I’m migrating RT machine to new one.
After backup as below,
/usr/local/bin/mysqldump --user=root --password=xxx rt3 > ./backup.sql

I tried to restore on new machine as below,
/usr/local/bin/mysql --user=root --password=xxx rt3 < ./backup.sql

But I got following error message instead of restoring.
“ERROR 1050 at line 11: Table ‘ACL’ already exists”

Do you have any good idea ?
Is there any recommendation for that kind of job ?

Thanks

Regards,
Han