<p dir="ltr">Perform a mysqldump of the old database, and import it into a new location as is.</p>
<p dir="ltr">Follow the instructions included with RT for a new installation, ignoring the database steps.</p>
<p dir="ltr">Add the new database connection details to your new installation's RT_SiteConfig.pm file (ensuring that the $DatabaseAdmin value is set appropriately).</p>
<p dir="ltr">Run sbin/rt-setup-database from the root of the new RT installation with the appropriate options (including "--action upgrade"). See "--help".</p>
<p dir="ltr">When I upgrade, I tend to follow the steps above rather than upgrading in place like RT's instructions suggest.<br>
</p>
<br><div class="gmail_quote">On Fri, 16 Jan 2015 12:53 am Iain Vowles <<a href="mailto:iain.vowles@mcgill.ca">iain.vowles@mcgill.ca</a>> wrote:<br><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">
<div lang="EN-US" link="blue" vlink="purple">
<div>
<p class="MsoNormal">Hi,<u></u><u></u></p>
<p class="MsoNormal"><u></u> <u></u></p>
<p class="MsoNormal">We are new to the whole RT upgrading game and would like to do the following:<u></u><u></u></p>
<p class="MsoNormal"><u></u> <u></u></p>
<p><u></u><span style="font-family:Symbol"><span>·<span style="font:7.0pt "Times New Roman"">
</span></span></span><u></u>A clean install the new RT 4.2.9 on a new server (server is already configured with the correct Apache (2.2.15), Perl (5.10.1), and MySQL (5.1.73))<u></u><u></u></p>
<p><u></u><span style="font-family:Symbol"><span>·<span style="font:7.0pt "Times New Roman"">
</span></span></span><u></u>Export the MySQL data from our old RT server - version 3.6.11
<u></u><u></u></p>
<p><u></u><span style="font-family:Symbol"><span>·<span style="font:7.0pt "Times New Roman"">
</span></span></span><u></u>Import the data to the new 4.2.9 version<u></u><u></u></p>
<p class="MsoNormal"><u></u> <u></u></p>
<p class="MsoNormal">Can someone let us know how to go about this.<u></u><u></u></p>
<p class="MsoNormal"><u></u> <u></u></p>
<p class="MsoNormal">Many Thanks,<u></u><u></u></p>
<p class="MsoNormal"><u></u> <u></u></p>
<p class="MsoNormal">Iain Vowles<u></u><u></u></p>
<p class="MsoNormal"><u></u> <u></u></p>
<p class="MsoNormal"><u></u> <u></u></p>
<p class="MsoNormal"><b><span style="font-size:9.0pt;color:red">Iain Vowles</span></b><span style="font-size:9.0pt;color:#5e5e5e"> | Senior Analyst, Information Services/ Analyst Senior, Services d’Information<u></u><u></u></span></p>
<p class="MsoNormal"><b><span style="font-size:9.0pt;color:red">Université McGill University</span></b><span style="font-size:9.0pt;color:#5e5e5e"> | University Advancement / Avancement universitaire<br>
1555, rue Peel, # 937 | Montréal (Québec) Canada H3A 3L8 <br>
<b>T</b> 514.398.8098 | <b>C</b> 514.443.0328 | <b>E</b> <b><a href="mailto:iain.vowles@mcgill.ca" target="_blank"><span style="color:blue">iain.vowles@mcgill.ca</span></a></b>
<br>
<a href="http://www.mcgill.ca" target="_blank"><b><span style="color:blue">McGill</span></b></a> | <a href="http://aoc.mcgill.ca/" target="_blank">
<b><span style="color:blue">AOC</span></b></a><b> </b>| <a href="https://www.facebook.com/McGillUniversityAlumni" target="_blank">
<b><span style="color:blue">Facebook</span></b></a> | <a href="http://twitter.com/McGillAlumni" target="_blank">
<b><span style="color:blue">Twitter</span></b></a> | <a href="http://www.linkedin.com/groups?home=&gid=49847&trk=anet_ug_hm" target="_blank">
<b><span style="color:blue">LinkedIn</span></b></a> | <a href="https://www.alumni.mcgill.ca/aoc/online-giving/step1.php?new=1" target="_blank">
<b><span style="color:blue">Give now / Faire un don</span></b></a><a href="https://www.alumni.mcgill.ca/aoc/online-giving/step1.php?new=1" target="_blank"><span style="color:#5e5e5e"><br>
</span></a><br>
</span><b><span style="font-size:9.0pt;color:#424242">This message is confidential.</span></b><span style="font-size:9.0pt;color:#5e5e5e">
</span><i><span style="font-size:9.0pt;color:#7f7f7f">If you are not the person to whom it is addressed, please alert us as soon as possible and delete it immediately. If you are not the correct addressee, any disclosure, copying or other distribution of this
message is strictly prohibited.</span></i><span style="font-size:9.0pt;color:#5e5e5e">
</span><b><span style="font-size:9.0pt;color:#424242">/ Ce message est confidentiel.</span></b><span style="font-size:9.0pt;color:#5e5e5e">
</span><i><span style="font-size:9.0pt;color:#7f7f7f">Si vous n’êtes pas la personne à laquelle il est destiné veuillez nous en aviser le plus tôt possible et le détruire immédiatement. Si ce message ne vous est pas destiné, il vous est strictement interdit
de divulguer, de copier ou de distribuer le contenu de ce message par quelque moyen que ce soit.</span></i><span style="font-size:9.0pt;color:#5e5e5e">
</span><u></u><u></u></p>
<p class="MsoNormal"><u></u> <u></u></p>
</div>
</div>
</blockquote></div>