[rt-users] Backup and restore RT3.

[Richie Crews]

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 at 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 at icraft21.com] 
Sent: Thursday, November 20, 2003 12:57 AM
To: rt-users at 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
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.bestpractical.com/pipermail/rt-users/attachments/20031120/e066fd88/attachment.htm>