14 msgHow to delete encoders from mythtv database
8 msgHelp - Cannot scheduled any programs - to record
9 msgRemotes
4 msgPreScaling Image Percent Bar Stuck at 99 % afte...
12 msgmyth and unicode..
2 msgIs there support for recgroup='Deleted' in 0.21?
5 msgIs there any way to disable live TV preview in ...
1 msgnuvexport fails with'mythtranscode had died early
4 msgAnyway to export stats from Mythtv db
12 msgYes, it's overkill,but here is the list for my ...

URGENT HELP!!! Where does mythtv-setup put theb...
\ Michael Jones (11 May 2008)
. \ Arthur Pemberton (11 May 2008)
. . \ Michael Jones (11 May 2008)
. \ Nick Morrott (11 May 2008)
. . \ Michael T. Dean (11 May 2008)
. . . \ Michael Jones (11 May 2008)
. . . . \ Michael Jones (11 May 2008)
. . . . . \ Michael Jones (11 May 2008)
. . . . . . \ Marc (11 May 2008)
. . . . . . \ Michael T. Dean (11 May 2008)
. . . . . . . \ Michael Jones (12 May 2008)
. . . . . . . . \ Michael T. Dean (12 May 2008)
. . . . . . . . . \ Michael Jones (13 May 2008)
. . . . . \ Michael T. Dean (11 May 2008)
. . . . \ Michael T. Dean (11 May 2008)

3 msgWindows DVB (BDA Drivers) Streaming to MythTV?
1 msgBrazillian User Group
5 msgScaling issues with 0.21
5 msgInstall MythTV SVN on Fedora wiki page upgraded...
1 msgReports re: MythTV and Fedora 9?
3 msgPrebuffering Pause despite very little resource...
3 msgRingBuf(/home/myth/live/): Invalid file (fd -1)...
6 msgProblem creating a custom recording
10 msgPartition full - help!
Subject:Re: URGENT HELP!!! Where does mythtv-setup put the backup after a schema update? SOLVED?
Group:Mythtv-users
From:Michael T. Dean
Date:11 May 2008


 
On 05/11/2008 01:15 AM, Michael Jones wrote:
> Well.. I may have figured out a solution:
>
> I manually changed the mythconverg>settings>DBSchemaVer from 1220 to
> 1214
>
> Before, mythbackend would fail to start, this time it started up as if
> it was running normally. I ran mythtv-setup, everything seemed Ok.. I
> ran the mythtv-setup on the slave frontend, everything seemed Ok. I
> started the frontend.. everything SEEMS fine..
>
> This SEEMS to work, but I'm a little nervous. What are the
> ramifications of doing this? What actually gets changed when
> updating to schema version 1220?

Pretty much the entire database got modified in some ways. The
character set conversion is a big, virtually undo-able change. Go with
the week-old backup. If you don't, you /will/ have issues in the
future--even when doing the upgrade from your current (now corrupt)
database to the one required for 0.22. Even if you were to change the
DBSchemaVer back to 1220 before upgrading to 0.22, your current MythTV
is writing 0.21 information to the DB and ignoring all the 0.22 fields, etc.

And, you may want to set up a more-frequent backup. I wrote a script
(that should become a part of MythTV 0.22) that you can use for this.
It determines the database information and pretty much everything else
you need to make a backup. Use --help to find out how to use it.
There's also a restore companion script (which you can use to restore
the week-old backup).

See http://www.gossamer-threads.com/lists/mythtv/users/332734#332734 for
links to the scripts. Note, also, that there's no reason you need to do
the "spring-cleaning" (i.e. just restore your week old backup and you're
good to go). You can import the recordings that occurred in the last
week with myth.rebuild_database.pl and use myth.find_orphans.pl to
identify "unidentified" files in the recordings directories (or just
stick the unidentified recordings into MythVideo, watch them there and
delete them, and let Myth re-record them on re-run. Though this may
seem like a lot of work, it's a /much/ better solution.

Mike
_______________________________________________
mythtv-users mailing list
mythtv-users
http://mythtv.org/cgi-bin/mailman/listinfo/mythtv-users


© 2004-2008 readlist.com