[mythtv-users] Transferring database & recordings from one box to another

[Azmat]

Never mind about my last post.  I realized that the new database
format requires the actual file name in the entry.  Once I provided
that it started working.  I think I'll just have to write a script to
automate this for me.

Thanks.

On 11/28/06, Azmat <azmat.hussain at gmail.com> wrote:
> So transferring the database from my old to my new box hasn't turned
> out to be as straightforward as I previously thought.  First of all,
> because the old database uses mysql server 3.23 and the new one uses
> mysql 5.0, the database entries are different and required me to do
> some tweaking.  I'm currently trying to simply copy a single database
> entry from the old box to the new box and then copy over its files
> (the .nuv and .nuv.png).  I've done that and now my show appears in
> the recorded list on the new box.  However, when I attempt to play it
> back, I get no picture (a blank screen) and the following error
> appears in my terminal:
>
> RingBuf(/video/recordings/): Invalid file (fd -1) when opening
> '/video/recordings/'.
> TV: Attempting to change from None to WatchingPreRecorded
>
> Another thing I'd like to note is that this recorded show is still in
> .nuv format.  I'm under the impression that .nuv is basically the same
> as .mpg, however even when I rename it to .mpg, there is no change in
> the result.
>
> Does anyone have any ideas?  Is there a better way to do this?
>
> Thanks.
>
> On 10/20/06, Fred Squires <fsquires at gmail.com> wrote:
> > On 10/19/06, Azmat <azmat.hussain at gmail.com> wrote:
> > > Sorry I wasn't more specific.  Yes, I'm planning on taking them from
> > > an existing LVM partition in the old machine to an LVM partition in
> > > the new machine.  I was thinking that if I backed up the mysql
> > > database on the old machine, copy it to the new machine, and then
> > > restore the database, then I might be able to simply hook up the
> > > drives to the new machine and I should be good to go.  I was just
> > > worried that I might be making a lot of assumptions and wanted to
> > > cover my bases.
> > >
> >
> > That's basically all I did when I changed servers.
> > I just copied the recordings and the mysql DB (I didn't do a restore, I just
> > overwrote the mysql files with the ones from the old machine).  Then I
> > started up mysql and mythbackend and everything worked.
> > Also this was an upgrade from .18.1 to .20.
> >
> > --
> > It was supposed to be so Easy.
> > _______________________________________________
> > mythtv-users mailing list
> > mythtv-users at mythtv.org
> > http://mythtv.org/cgi-bin/mailman/listinfo/mythtv-users
> >
> >
> >
>