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

[Azmat]

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
>
>
>