<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//EN">
<HTML>
<HEAD>
<META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=US-ASCII">
<META NAME="Generator" CONTENT="MS Exchange Server version 5.5.2653.12">
<TITLE>RE: [rt-users] Backup and restore RT3.</TITLE>
</HEAD>
<BODY>
<P><FONT SIZE=2>We use the following command for our RT systems</FONT>
</P>
<P><FONT SIZE=2>/usr/local/bin/mysqldump --tab=/usr/local/dbbkup --opt rt3 -u XXXX --password=XXXX</FONT>
</P>
<P><FONT SIZE=2>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.</FONT></P>
<P><FONT SIZE=2>Richie Crews</FONT>
<BR><FONT SIZE=2>Team Lead of Unix Systems and Technologies</FONT>
<BR><FONT SIZE=2>Red Hat Certified Engineer</FONT>
<BR><FONT SIZE=2>Email: rcrews@intercall.com</FONT>
<BR><FONT SIZE=2>Cell: (706) 773 - 3436</FONT>
<BR><FONT SIZE=2>Desk: (706) 634 - 3681</FONT>
<BR><FONT SIZE=2>Fax: (706) 634 - 3831</FONT>
<BR><FONT SIZE=2> </FONT>
<BR><FONT SIZE=2>"Providing security for your email needs"</FONT>
<BR><FONT SIZE=2>Stop Spam, Support RBL <A HREF="http://www.mail-abuse.org" TARGET="_blank">http://www.mail-abuse.org</A></FONT>
</P>
<P><FONT SIZE=2>-----Original Message-----</FONT>
<BR><FONT SIZE=2>From: Hangu Jeong [<A HREF="mailto:hgjeong@icraft21.com">mailto:hgjeong@icraft21.com</A>] </FONT>
<BR><FONT SIZE=2>Sent: Thursday, November 20, 2003 12:57 AM</FONT>
<BR><FONT SIZE=2>To: rt-users@lists.fsck.com</FONT>
<BR><FONT SIZE=2>Subject: [rt-users] Backup and restore RT3.</FONT>
</P>
<P><FONT SIZE=2>Hi !</FONT>
</P>
<P><FONT SIZE=2>I'm migrating RT machine to new one.</FONT>
<BR><FONT SIZE=2>After backup as below, </FONT>
<BR><FONT SIZE=2>/usr/local/bin/mysqldump --user=root --password=xxx rt3 > ./backup.sql</FONT>
</P>
<P><FONT SIZE=2>I tried to restore on new machine as below,</FONT>
<BR><FONT SIZE=2>/usr/local/bin/mysql --user=root --password=xxx rt3 < ./backup.sql</FONT>
</P>
<P><FONT SIZE=2>But I got following error message instead of restoring.</FONT>
<BR><FONT SIZE=2>"ERROR 1050 at line 11: Table 'ACL' already exists"</FONT>
</P>
<P><FONT SIZE=2>Do you have any good idea ?</FONT>
<BR><FONT SIZE=2>Is there any recommendation for that kind of job ?</FONT>
</P>
<P><FONT SIZE=2>Thanks</FONT>
</P>
<P><FONT SIZE=2>Regards,</FONT>
<BR><FONT SIZE=2>Han</FONT>
</P>
</BODY>
</HTML>