<html>
<head>
<meta http-equiv="content-type" content="text/html; charset=ISO-8859-1">
</head>
<body bgcolor="#FFFFFF" text="#000000">
I am upgrading from MythTV 0.21 to 0.25.<br>
<br>
Since my 0.21 is running on Ubuntu 7.04, I am planning on
reformatting the drive and reinstalling from scratch.<br>
<br>
Prior to doing that, I am using 2 VMs to test my upgrade process so
I don't have any surprises.<br>
<br>
I created two VMs, one running 0.24+fixes (Mythbuntu 11.10) and
0.25+fixes (Mythbuntu 12.04).<br>
<br>
I have read a couple of posts on this forum, which are specific that
0.21 cannot be upgraded directly to 0.25.<br>
<font color="black" face="Verdana,Arial,Helvetica" size="2"><font
color="black" face="Verdana,Arial,Helvetica" size="2"><b><br>
Notice for users of old (pre-0.22) MythTV versions</b></font></font><br>
<a class="moz-txt-link-freetext" href="http://www.gossamer-threads.com/lists/mythtv/users/507819">http://www.gossamer-threads.com/lists/mythtv/users/507819</a><br>
<font color="black" face="Verdana,Arial,Helvetica" size="2"><font
color="black" face="Verdana,Arial,Helvetica" size="2"><b>Changing
from 0.21 to 0.25 using new hardware</b></font></font><br>
<a class="moz-txt-link-freetext" href="http://www.gossamer-threads.com/lists/mythtv/users/508796">http://www.gossamer-threads.com/lists/mythtv/users/508796</a><br>
<br>
I have also read this wiki entry:<br>
<a class="moz-txt-link-freetext" href="http://www.mythtv.org/wiki/Database_Backup_and_Restore">http://www.mythtv.org/wiki/Database_Backup_and_Restore</a><br>
<br>
In the wiki it specifically mentions:<br>
<br>
***<br>
<h4> <span class="mw-headline"
id="Change_the_hostname_of_a_MythTV_frontend_or_backend"> Change
the hostname of a MythTV frontend or backend </span></h4>
<p>Before changing the hostname of a MythTV frontend or backend,
make sure you <a
href="http://www.mythtv.org/wiki/Database_Backup_and_Restore#Quick_Start"
title="Database Backup and Restore">create a good database
backup</a>, so that you can get back to a known state if things
go wrong.
</p>
<p>When changing the hostname of your system, you <i>must</i>
perform the following actions <i>before</i> you start any MythTV
programs. If you start a MythTV program before modifying the
hostname in the database, the program will create new entries with
the new hostname, meaning that the following procedure is likely
to fail because of duplicate entries.
</p>
<p>It is also critical to ensure you do not change the name of a
host to the name of another already-existing host in the
database--doing so will cause duplicate entries. Instead, if
necessary, run the command below multiple times, using a temporary
"placeholder" hostname to ensure the different hosts are not
improperly merged.
</p>
<p>Note that changing the hostname is performed on an existing
database and does not restore a database. Therefore, to change a
hostname, ensure that the database exists (restore an old
database, as above, if necessary) and execute the following
command, replacing "XXXX" and "YYYY" with appropriate values for
the old and new hostnames, respectively:<br>
</p>
<p>***</p>
<p>So, if I consider sequence.<br>
</p>
<p>1. I cannot simply save the backup and restore it to my newly
formatted (same hardware) machine since it was at 0.21.<br>
2. So I have to upgrade the database on a different 0.24 machine
first.<br>
3. This means I have to technically change the hostname, or I
might run into duplicates. But I have to do this _before_ running
mythtv-setup to perform the upgrade.<br>
4. After running mythtv-setup, I then run mythtv-frontend which
upgrades more of the database (videos and something else).<br>
5. Then I would reformat my 0.21 machine, reinstall 12.04 and
0.25.<br>
6. Perform the same steps over again, this time with another
hostname change, but actually back to the original 0.21 name.<br>
</p>
<p><br>
So I am not sure which is the correct approach. I could forget
the hostname change completely and eventually dump the fully
upgraded database back into my fresh 0.25 install.</p>
<p><br>
The other concern I had was, one of the threads above indicated,
upgrading (even through the intermediate steps) may not work
completely with 0.25 and a fresh database might be a better
approach. If this is true, what process do you follow to dump all
your recordings, schedules and what not back into the fresh 0.25
database?<br>
</p>
<p><br>
Right now, I will be following this sequence (without the hostname
change on purpose, though each machine has different hostnames):<br>
</p>
<p>0.21</p>
<p>/usr/share/mythtv/mythconverg_backup.pl <br>
</p>
<p>scp file to 0.24 machine<br>
</p>
<p>0.24<br>
</p>
<p>sudo stop mythtv-backend<br>
/usr/share/mythtv/mythconverg_restore.pl --drop_database
--create_database --filename mythconverg-1214-one-from-021.sql.gz<br>
</p>
mythtv-setup<br>
- Upgrades most of the schema<br>
mythtv-frontend<br>
- Upgrades the rest of the schema<br>
<p>/usr/share/mythtv/mythconverg_backup.pl <br>
</p>
<p>scp file to 0.25 machine <br>
<br>
</p>
0.25<br>
<p>sudo stop mythtv-backend<br>
/usr/share/mythtv/mythconverg_restore.pl --drop_database
--create_database --filename mythconverg-1214-one-from-024.sql.gz<br>
</p>
mythtv-setup<br>
- Upgrades most of the schema<br>
mythtv-frontend<br>
- Upgrades rest of the schema<br>
<br>
<br>
Format 0.21 machine.<br>
Install a fresh Mythbuntu 12.04, 0.25 machine.<br>
scp file from test 0.25 machine.<br>
<p>sudo stop mythtv-backend<br>
/usr/share/mythtv/mythconverg_restore.pl --drop_database
--create_database --filename mythconverg-1214-one-from-025.sql.gz<br>
</p>
<br>
The recordings are all on different partitions from the main Ubuntu
install, so they should just remain in place. So after the restore,
I believe they should be immediately accessible.<br>
<br>
<br>
Any help is appreciated.<br>
<br>
Thanks,<br>
Dave<br>
<br>
</body>
</html>