<div dir="ltr"><br><div class="gmail_extra"><br><br><div class="gmail_quote">On Tue, Aug 13, 2013 at 1:40 PM, Lois Bennett <span dir="ltr"><<a href="mailto:lois.bennett@channing.harvard.edu" target="_blank">lois.bennett@channing.harvard.edu</a>></span> wrote:<br>
<blockquote class="gmail_quote" style="margin:0px 0px 0px 0.8ex;border-left-width:1px;border-left-color:rgb(204,204,204);border-left-style:solid;padding-left:1ex"><div dir="ltr">Hello,<br><br>I have read the documentation on upgrading and none of the particulars exactly fit.<br>
<br>I have a new VM (Centos6). I have installed RT 4.0.17 completely vanilla. <br><br>Old mysql:<br>mysql Ver 14.12 Distrib 5.0.81, for unknown-linux-gnu (x86_64) using readline 5.2<br>
Old RT is 3.8.9<br><br>New mysql:<br>mysql Ver 14.14 Distrib 5.1.66, for redhat-linux-gnu (x86_64) using readline 5.1<br><br>All has gone well. <br><br>I have gotten as far as running make initialize-database.<br><br>
Now what? I am not clear if the next step is to take a dump of the running server and copy it to the new server then run update database? <br><br></div></blockquote><div><br></div><div>This is what I did as next steps</div>
<div><br></div><div>- copy over the RT_SiteConfig.pm from /opt/rt3/etc to /opt/rt4/etc</div><div>- comment out the plugins</div><div>- mysql> drop database rt4;</div><div>- mysql> create database rt4;</div><div>- # mysql < dump.from.rt3.sql</div>
<div>- src/rt-4.0.17# sudo make upgrade-database</div><div>- uncomment the plugins from RT_SiteConfig.pm</div><div>- .. follow the rest of the steps from README ..</div><div><br></div><div><br></div><blockquote class="gmail_quote" style="margin:0px 0px 0px 0.8ex;border-left-width:1px;border-left-color:rgb(204,204,204);border-left-style:solid;padding-left:1ex">
<div dir="ltr">Do I need to do anything to the database before I use it?<br><br>I see someone else doing this:<br>
> 1. make a clone of the existing RT,<br>> 2. upgrade it to 4.0.13<br>> 3. do a mysqldump on the upgraded clone<br>> 4. restore the dump on the new server.<br><br>Is it recommended to actually clone the old and upgrade it in place? <br>
Could I simply restore a backup from the old on the new and run <br> make upgrade-database<br><br>I know I will need to setup users, groups, cron, email and probably some other things as well.<br><br>T<div style="font-family:arial,helvetica,sans-serif;display:inline">
hank you for your help.</div><div><div style="font-family:arial,helvetica,sans-serif;display:inline"><br></div></div><div><div style="font-family:arial,helvetica,sans-serif;display:inline">
Peace,</div></div><div><div style="font-family:arial,helvetica,sans-serif;display:inline">Lois</div><br><br>--<br>Lois Bennett, MSEE<br>Senior System Administrator<br>Channing Laboratory<br>Brigham & Women's Hospital<br>
A Teaching Affiliate of<br>Harvard Medical School and<br>Harvard School of Public Health</div></div>
</blockquote></div><br><br clear="all"><div><br></div>-- <br>Asif Iqbal<br>PGP Key: 0xE62693C5 KeyServer: <a href="http://pgp.mit.edu">pgp.mit.edu</a><br>A: Because it messes up the order in which people normally read text.<br>
Q: Why is top-posting such a bad thing?<br><br>
</div></div>