[mythtv-users] Upgrading from .20 to .27

[Fredrik Hallgarde]

On 01/26/2014 08:28 PM, Lord Kage wrote:
> Still no love.
>
> At this point, I would just settle for a sane set of instructions on 
> how to dump the DB (either using mysqldump or mythconverg_backup.pl 
> <http://mythconverg_backup.pl>), then update its schema/data for .27 
> before importing into the new machine.
>
Hi,

I recently upgraded from 0.21 to 0.27, changing hostname in the process. 
I will _briefly_ describe how I did it.

1. Installed new backend OS (Ubuntu 12.04 desktop) on new harddrive 
(hostname=NEW)
2. Configured Mythtv 0.27 on NEW with clean DB to verify function
3. Configured Mythtv 0.27 frontend on old laptop (my temporary frontend)
4. Installed a virtual machine with Ubuntu 10.04 + Mythtv 0.24 
(hostname=TEMP)
5. mythconverg_backup.pl (from 0.27) on NEW (to keep a known ok 0.27 DB)
6. mythconverg_backup.pl (from 0.27) on OLD (my current DB)
7. on NEW: mythconverg_restore.pl --drop-database --create-database 
--filename mythconverg-1214-20131230210511.sql.gz --verbose
8.  /usr/bin/mythconverg_restore.pl --change_hostname 
--old_hostname="OLD" --new_hostname="TEMP" --verbose
9. Start mythtv-setup on virtual machine (TEMP), point at database on 
NEW (will upgrade database, more details below)
10. Run frontend on TEMP
11. /usr/bin/mythconverg_restore.pl --change_hostname 
--old_hostname="TEMP" --new_hostname="NEW" --verbose
12. mythtv-setup on NEW (next upgrade step of DB)
13. mythfrontend on NEW (final DB upgrades)
14. DONE!

The database can be upgraded from 0.21 (db 1214)-->0.24 (db 
1264)-->0.27  (db1317) (and  0.20 is also covered by 0.24 as Michael has 
pointed out).
I noticed that upgrade from db-schema 1215 to 1216 (just after leaving 
0.21/1214) the upgrade step takes "forever!", or more exactly 5.5hours 
with almost no activity (timeout?) I didn't analyse further, there are 
some comments online about it.

I ran a similar upgrade for a friend but for his DB the upgrade failed 
in step 1231 (i.e. after close to 6h), we decided to run 
mythlink/mythrename --link on his recordings (to make them more 
accessible as videos) and start a clean database.

I'd be happy to expand on the details but it will have to wait a few days.

Fredrik
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://www.mythtv.org/pipermail/mythtv-users/attachments/20140126/7dd841b4/attachment-0001.html>