[rt-users] Backup and restore RT3.

[Benjamin Boksa]

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

Benjamin Boksa

b.boksa at 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

http://www.sidebysite.de/
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.2.3 (Darwin)

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