<html><body style="word-wrap: break-word; -webkit-nbsp-mode: space; -webkit-line-break: after-white-space; "><p><font size=2 color=navy face=Arial>
I won't be able to answer that honestly :) we just moved up to MySQL 5. I did however have issues with my backups (attachments) until I saw that note in the wiki. </font></p>
<p><hr size=2 width="100%" align=center tabindex=-1>
<font face=Tahoma size=2>
<b>From</b>: Tom Smith <aliase573201@mac.com>
<br><b>To</b>: Helmuth Ramirez
<br><b>Cc</b>: RT Users <rt-users@lists.bestpractical.com>
<br><b>Sent</b>: Thu Aug 28 09:26:52 2008<br><b>Subject</b>: Re: [rt-users] DB import
<br></font></p>
<div>On MySQL 5, I used this command: mysqldump --add-drop-table -u rt_user -p rt3 > rt3.sql .</div><div><br></div><div>The conversion seemed to go fine and I haven't noticed any problems.</div><div><br></div><div>By not using the command listed below, is there a chance that something didn't make it across in my migration?</div><br><div><div>On Aug 28, 2008, at 6:54 AM, Helmuth Ramirez wrote:</div><br class="Apple-interchange-newline"><blockquote type="cite"> <div class="Section1"><p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri","sans-serif"; color:#1F497D">Dumping it:<o:p></o:p></span></p><p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri","sans-serif"; color:#1F497D"><o:p> </o:p></span></p><p class="MsoNormal"><span style="font-size:10.0pt;font-family:"Courier New"">mysqldump --user=rt_user –-password=<password> --opt --skip-lock-tables<o:p></o:p></span></p><p class="MsoNormal"><span style="font-size:10.0pt;font-family:"Courier New""> --single-transaction --default-character-set=binary --databases rt3 > /home/mysql/rt.sql<o:p></o:p></span></p><p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri","sans-serif"; color:#1F497D"><o:p> </o:p></span></p><p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri","sans-serif"; color:#1F497D">Per <a href="http://wiki.bestpractical.com/view/MigrateToNewServer">http://wiki.bestpractical.com/view/MigrateToNewServer</a><o:p></o:p></span></p><p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri","sans-serif"; color:#1F497D"><o:p> </o:p></span></p><p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri","sans-serif"; color:#1F497D">Importing it<o:p></o:p></span></p><p class="MsoPlainText"><span style="font-family:"Courier New"">mysql -u root -p YOURDBNAME < PATHTOYOURDB.sql<o:p></o:p></span></p><p class="MsoPlainText"><span style="font-family:"Courier New""><o:p> </o:p></span></p><p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri","sans-serif"; color:#1F497D">Then you follow the upgrade instructions (important), and finally run the 4.0 -> 4.1 MySQL scripts…yes..even though you’re not running 4.0<o:p></o:p></span></p><p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri","sans-serif"; color:#1F497D"><o:p> </o:p></span></p><p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri","sans-serif"; color:#1F497D"><o:p> </o:p></span></p> <div> <div style="border:none;border-top:solid #B5C4DF 1.0pt;padding:3.0pt 0in 0in 0in"><p class="MsoNormal"><b><span style="font-size:10.0pt;font-family:"Tahoma","sans-serif"">From:</span></b><span style="font-size:10.0pt;font-family:"Tahoma","sans-serif""> rt-users-bounces@lists.bestpractical.com [<a href="mailto:rt-users-bounces@lists.bestpractical.com">mailto:rt-users-bounces@lists.bestpractical.com</a>] <b>On Behalf Of </b>Nick Price<br> <b>Sent:</b> Thursday, August 28, 2008 5:11 AM<br> <b>To:</b> <a href="mailto:rt-users@lists.bestpractical.com">rt-users@lists.bestpractical.com</a><br> <b>Subject:</b> [rt-users] DB import<o:p></o:p></span></p> </div> </div><p class="MsoNormal"><o:p> </o:p></p><p class="MsoNormal" style="margin-bottom:12.0pt"><span style="font-size:10.0pt; font-family:"Tahoma","sans-serif";color:black">Hello<br> <br> I am running rt-3.6.3 on a fedora 7 server with mysql 5.0.45-6.fc7<br> <br> I have a new setup on a new server fedora 9 and rt-3.8.1 also with mysql 5.0.51a-1.fc9.i386<br> <br> How can i import the database from the old server to the new server<br> keeping all the data intact<br> <br> many thanks<br> <br> Nick Price<o:p></o:p></span></p><p class="MsoNormal"><span style="font-size:10.0pt;font-family:"Tahoma","sans-serif""><o:p> </o:p></span></p> <div class="MsoNormal" align="center" style="text-align:center"><span style="font-size:10.0pt;font-family:"Tahoma","sans-serif""> <hr size="2" width="100%" align="center"> </span></div><p class="MsoNormal"><span style="font-size:10.0pt;font-family:"Tahoma","sans-serif"">Get ideas on sharing photos from people like you. Find new ways to share. <a href="http://www.windowslive.com/explore/photogallery/posts?ocid=TXT_TAGLM_WL_Photo_Gallery_082008" target="_new">Get Ideas Here!</a><o:p></o:p></span></p> </div><div style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; ">_______________________________________________</div><div style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; "><a href="http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users">http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users</a></div><div style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; min-height: 14px; "><br></div><div style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; ">Community help: <a href="http://wiki.bestpractical.com">http://wiki.bestpractical.com</a></div><div style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; ">Commercial support: <a href="mailto:sales@bestpractical.com">sales@bestpractical.com</a></div><div style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; min-height: 14px; "><br></div><div style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; min-height: 14px; "><br></div><div style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; ">Discover RT's hidden secrets with RT Essentials from O'Reilly Media.<span class="Apple-converted-space"> </span></div><div style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; ">Buy a copy at <a href="http://rtbook.bestpractical.com">http://rtbook.bestpractical.com</a></div> </blockquote></div><br></body></html>