<html xmlns:o="urn:schemas-microsoft-com:office:office" xmlns:w="urn:schemas-microsoft-com:office:word" xmlns="http://www.w3.org/TR/REC-html40">
<head>
<meta http-equiv=Content-Type content="text/html; charset=us-ascii">
<meta name=ProgId content=Word.Document>
<meta name=Generator content="Microsoft Word 11">
<meta name=Originator content="Microsoft Word 11">
<link rel=File-List href="cid:filelist.xml@01C55646.281BB0D0">
<!--[if gte mso 9]><xml>
<o:OfficeDocumentSettings>
<o:DoNotRelyOnCSS/>
</o:OfficeDocumentSettings>
</xml><![endif]--><!--[if gte mso 9]><xml>
<w:WordDocument>
<w:SpellingState>Clean</w:SpellingState>
<w:GrammarState>Clean</w:GrammarState>
<w:DocumentKind>DocumentEmail</w:DocumentKind>
<w:EnvelopeVis/>
<w:ValidateAgainstSchemas/>
<w:SaveIfXMLInvalid>false</w:SaveIfXMLInvalid>
<w:IgnoreMixedContent>false</w:IgnoreMixedContent>
<w:AlwaysShowPlaceholderText>false</w:AlwaysShowPlaceholderText>
<w:Compatibility>
<w:BreakWrappedTables/>
<w:SnapToGridInCell/>
<w:WrapTextWithPunct/>
<w:UseAsianBreakRules/>
<w:UseWord2002TableStyleRules/>
</w:Compatibility>
<w:BrowserLevel>MicrosoftInternetExplorer4</w:BrowserLevel>
</w:WordDocument>
</xml><![endif]--><!--[if gte mso 9]><xml>
<w:LatentStyles DefLockedState="false" LatentStyleCount="156">
</w:LatentStyles>
</xml><![endif]-->
<style>
<!--
/* Font Definitions */
@font-face
{font-family:"Bookman Old Style";
panose-1:2 5 6 4 5 5 5 2 2 4;
mso-font-charset:0;
mso-generic-font-family:roman;
mso-font-pitch:variable;
mso-font-signature:647 0 0 0 159 0;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{mso-style-parent:"";
margin:0in;
margin-bottom:.0001pt;
mso-pagination:widow-orphan;
font-size:12.0pt;
font-family:"Times New Roman";
mso-fareast-font-family:"Times New Roman";}
a:link, span.MsoHyperlink
{color:blue;
text-decoration:underline;
text-underline:single;}
a:visited, span.MsoHyperlinkFollowed
{color:purple;
text-decoration:underline;
text-underline:single;}
span.EmailStyle17
{mso-style-type:personal-compose;
mso-style-noshow:yes;
mso-ansi-font-size:10.0pt;
mso-bidi-font-size:10.0pt;
font-family:"Bookman Old Style";
mso-ascii-font-family:"Bookman Old Style";
mso-hansi-font-family:"Bookman Old Style";
color:windowtext;
font-weight:normal;
font-style:normal;
text-decoration:none;
text-underline:none;
text-decoration:none;
text-line-through:none;}
span.GramE
{mso-style-name:"";
mso-gram-e:yes;}
@page Section1
{size:8.5in 11.0in;
margin:1.0in 1.25in 1.0in 1.25in;
mso-header-margin:.5in;
mso-footer-margin:.5in;
mso-paper-source:0;}
div.Section1
{page:Section1;}
-->
</style>
<!--[if gte mso 10]>
<style>
/* Style Definitions */
table.MsoNormalTable
{mso-style-name:"Table Normal";
mso-tstyle-rowband-size:0;
mso-tstyle-colband-size:0;
mso-style-noshow:yes;
mso-style-parent:"";
mso-padding-alt:0in 5.4pt 0in 5.4pt;
mso-para-margin:0in;
mso-para-margin-bottom:.0001pt;
mso-pagination:widow-orphan;
font-size:10.0pt;
font-family:"Times New Roman";
mso-ansi-language:#0400;
mso-fareast-language:#0400;
mso-bidi-language:#0400;}
</style>
<![endif]-->
</head>
<body lang=EN-US link=blue vlink=purple style='tab-interval:.5in'>
<div class=Section1>
<p class=MsoNormal><font size=2 face="Bookman Old Style"><span
style='font-size:10.0pt;font-family:"Bookman Old Style"'>I am attempting to <span
class=GramE>migrate</span> our rt3 database from our Win32 3.0.12 version of RT
to a RHEL4 box with RT 3.4.2.<span style='mso-spacerun:yes'> </span>I
will be doing a mysqldump in the morning from the Windows machine but, to be
honest, I’m lost from there.<span style='mso-spacerun:yes'>
</span>Has anyone done this or can anyone give me some general directions on
how to move the database from one machine to the other and ensure that the
schema is correct?<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 face="Bookman Old Style"><span
style='font-size:10.0pt;font-family:"Bookman Old Style"'>Here is what I have
right now:<o:p></o:p></span></font></p>
<p class=MsoNormal><span class=GramE><font size=2 face="Bookman Old Style"><span
style='font-size:10.0pt;font-family:"Bookman Old Style"'>RT 3.0.12 for Windows
installed on a 2000 Server box with about 200 tickets.</span></font></span><font
size=2 face="Bookman Old Style"><span style='font-size:10.0pt;font-family:"Bookman Old Style"'><o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 face="Bookman Old Style"><span
style='font-size:10.0pt;font-family:"Bookman Old Style"'><o:p> </o:p></span></font></p>
<p class=MsoNormal><span class=GramE><font size=2 face="Bookman Old Style"><span
style='font-size:10.0pt;font-family:"Bookman Old Style"'>RT 3.4.2 installed on
RHEL4.</span></font></span><font size=2 face="Bookman Old Style"><span
style='font-size:10.0pt;font-family:"Bookman Old Style"'><o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 face="Bookman Old Style"><span
style='font-size:10.0pt;font-family:"Bookman Old Style"'><o:p> </o:p></span></font></p>
<p class=MsoNormal><font size=2 face="Bookman Old Style"><span
style='font-size:10.0pt;font-family:"Bookman Old Style"'>I’ve tested the
instance on the redhat box and it’s working properly so I just need to
move my database over.<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 face="Bookman Old Style"><span
style='font-size:10.0pt;font-family:"Bookman Old Style"'><o:p> </o:p></span></font></p>
<p class=MsoNormal><font size=2 color=green face="Bookman Old Style"><span
style='font-size:10.0pt;font-family:"Bookman Old Style";color:green;mso-no-proof:
yes'>Thanks,</span></font><span style='mso-no-proof:yes'><o:p></o:p></span></p>
<p class=MsoNormal><font size=2 color=green face="Bookman Old Style"><span
style='font-size:10.0pt;font-family:"Bookman Old Style";color:green;mso-no-proof:
yes'> mhb</span></font><span style='mso-no-proof:yes'><o:p></o:p></span></p>
<p class=MsoNormal><font size=3 face="Times New Roman"><span style='font-size:
12.0pt;mso-no-proof:yes'> <o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 color=green face="Bookman Old Style"><span
style='font-size:10.0pt;font-family:"Bookman Old Style";color:green;mso-no-proof:
yes'>Michael H. Brown</span></font><span style='mso-no-proof:yes'><o:p></o:p></span></p>
<p class=MsoNormal><font size=2 color=green face="Bookman Old Style"><span
style='font-size:10.0pt;font-family:"Bookman Old Style";color:green;mso-no-proof:
yes'>Network Administrator</span></font><span style='mso-no-proof:yes'><o:p></o:p></span></p>
<p class=MsoNormal><font size=2 color=green face="Bookman Old Style"><span
style='font-size:10.0pt;font-family:"Bookman Old Style";color:green;mso-no-proof:
yes'>Senex Services Corp.</span></font><span style='mso-no-proof:yes'><o:p></o:p></span></p>
<p class=MsoNormal><font size=2 color=green face="Bookman Old Style"><span
style='font-size:10.0pt;font-family:"Bookman Old Style";color:green;mso-no-proof:
yes'>317.613.3000 ext. 217</span></font><span style='mso-no-proof:yes'><o:p></o:p></span></p>
<p class=MsoNormal><font size=2 color=green face="Bookman Old Style"><span
style='font-size:10.0pt;font-family:"Bookman Old Style";color:green;mso-no-proof:
yes'><a href="http://www.senexservicescorp.com">http://www.senexservicescorp.com</a></span></font><span
style='mso-no-proof:yes'><o:p></o:p></span></p>
<p class=MsoNormal><font size=3 face="Times New Roman"><span style='font-size:
12.0pt;mso-no-proof:yes'> </span><o:p></o:p></font></p>
<p class=MsoNormal><font size=3 face="Times New Roman"><span style='font-size:
12.0pt'><o:p> </o:p></span></font></p>
</div>
</body>
</html>