<html><body style="word-wrap: break-word; -webkit-nbsp-mode: space; -webkit-line-break: after-white-space; ">
<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>