<html>
<head>
<meta content="text/html; charset=ISO-8859-1"
http-equiv="Content-Type">
</head>
<body text="#000000" bgcolor="#FFFFFF">
<div class="moz-cite-prefix">Thanks for that Kevin,<br>
<br>
I meant the README Docs in the installer archive mostly.<br>
<br>
My concern with the migration is that I used custom statuses for
queues and I have to now use the LifeCycle set up. I wasn't sure
how the DB restore would go because I imagine I'm going to have
different fields in my database than what 4.0.18 expects. Anyway
- installing 4.0.14 on my new server now and will get back I'm
sure if I run into any troubles...<br>
<br>
regards<br>
<br>
<div class="moz-signature">
<div style="font-family:Arial;font-size:12px">
<p><strong>Paul O’Rorke</strong><br>
Tracker Software Products<br>
<a href="mailto:paul.ororke@tracker-software.com">paul@tracker-software.com</a></p>
<br>
</div>
</div>
On 7/25/2013 9:32 AM, Kevin Falcone wrote:<br>
</div>
<blockquote cite="mid:20130725163239.GO22003@jibsheet.com"
type="cite">
<pre wrap="">On Wed, Jul 24, 2013 at 08:36:43PM -0700, Paul O'Rorke wrote:
</pre>
<blockquote type="cite">
<pre wrap=""> From what I've read it seems that the best approach might be to:
1. make a clone of the existing RT,
2. upgrade it to 4.0.13
3. do a mysqldump on the upgraded clone
4. restore the dump on the new server.
</pre>
</blockquote>
<pre wrap="">
Since you have a new server, upgrading should be easy, if something
fails, you just start again on the new server. You're not in any way
touching production until the final cutover.
I always:
Install RT 4.0.14 on the new server
mysqldump the old server
import on the new server
run make upgrade-database
test
turn off the old server
do a final dump, import, upgrade
go forth and rejoice.
</pre>
<blockquote type="cite">
<pre wrap=""> It's the details of step 4 I'm concerned about. If I set up the database on the new server
and restore it from the dump do I then use make upgrade on the new server? I don't understand
what the right process would be to make sure the new server has mailgate, users etc and can
accept the dump.
</pre>
</blockquote>
<pre wrap="">
You have to copy things like cron jobs and your mailgate config.
I don't understand what you mean by 'users etc and can accept the
dump'?
If you want to create a very empty DB on the rt4 host, run
/opt/rt4/sbin/rt-setup-databas --action create,acl
then restore your dump
You don't say what docs you've reviewed, but I frequently recommend to
the list our upgrading and README rather than any third party guides
as well as this quite old but still surprisingly relevant blog post I
wrote.
<a class="moz-txt-link-freetext" href="http://blog.bestpractical.com/2011/07/upgrading-to-rt-4.html">http://blog.bestpractical.com/2011/07/upgrading-to-rt-4.html</a>
-kevin
</pre>
</blockquote>
<br>
</body>
</html>