<div dir="ltr"><div class="gmail_extra"><div class="gmail_quote">On Wed, Sep 3, 2014 at 4:49 AM, Michael T. Dean <span dir="ltr"><<a href="mailto:mtdean@thirdcontact.com" target="_blank">mtdean@thirdcontact.com</a>></span> wrote:<br>
<blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">On 09/03/2014 06:20 AM, Jean-Yves Avenard wrote:<div class=""><br>
<blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">
On 3 September 2014 12:01, Joseph Fry wrote:<br>
<blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">
Just do an iterative upgrade... 0.23, 0.25, 0.27.... should be pretty<br>
flawless as far as upgrading the critical data (recording history).<br>
</blockquote>
Why?<br>
<br>
Only need to upgrade to 0.24 first, and then straight to 0.27...<br>
</blockquote>
<br></div>
Right, either upgrade to 0.22, 0.23, 0.24 or 0.25--whichever is easiest (i.e. if any is available from a package, then use it), then go to 0.27. Actually, to be more specific, use the most-current -fixes version of 0.22, 0.23, 0.24, or 0.25 to do the upgrade (we fixed some DB upgrade issues that occur with later versions of Qt/MySQL in the -fixes branches of some versions).<br>
<br>
A 2-step upgrade should work as well for you as upgrading version by version. The main problem with upgrading from an ancient version to a modern version is that the upgrade is generally tested against specific (current-at-the-time-of-release) versions of Qt, Qt-MySQL drivers, and MySQL. So if you don't use those versions of Qt/Qt-MySQL/MySQL, there's no benefit to the iterative upgrade for MythTV (and because MySQL upgrades are probably more work than MythTV upgrades, it's generally not worth trying).<br>
</blockquote></div><br></div><div class="gmail_extra">Don't forget these important steps: After each mythtv upgrade, *don't* run mythbackend yet. First backup the database (using <a href="http://mythconverg_backup.pl">mythconverg_backup.pl</a>) and store it somewhere safe (even better to back it up before upgrading the mythtv packages), then run mythtv-setup and let it upgrade the database. Note that any upgrade after version 0.24 might take quite a while because all the date/time fields have to be converted to UTC. Once the upgrade completes successfully, run mythbackend, then start mythfrontend to upgrade any frontend-specific database fields. You should also be sure to open any plugins you use (Videos, Music, etc.). Then exit mythfrontend, stop mythbackend, make a new database backup and then continue with your mythtv upgrade.<br>
<br></div><div class="gmail_extra">Sincerely,<br><br></div><div class="gmail_extra">Karl<br></div></div>