[mythtv-users] Watch Recordings List Empty

[kid charlemagne]

> On Sun, May 4, 2008 at 8:45 AM, kid charlemagne
> <kidcharlemagne87 at yahoo.com> wrote:
> > Okay, I just migrated a database from a 0.20.2
> install to a fresh 0.21
> > install on Ubuntu 8.04. I backed up my old
> database using:
> >
> > mysql -u mythtv -p mythconverg > mythdb.sql
> 
> I do hope you realise this command-line will do
> nothing except create
> a (blank) file called mythdb.sql. It will NOT back
> up the database. To
> do that you need to use:
> 
> mysqldump -u mythtv -p mythconverg >mythdb.sql
> 
> I am hoping this is just a typo on your part.

Yes, it was just a typo. I definitely used the
'mysqldump' command. As I said in my first message I
checked the contents of the database and my recordings
are there. My only problem is that the 'Watch
Recordings' screen is empty (as well as the 'Delete
Recordings' screen). I have since tried to import only
the database tables that contain the recordings
information (such as 'oldrecordings', 'recorded',
etc.) but I inevitably run into errors in mysql
regarding the format of the imported tables. This
happens even when I update the old 0.20.2 database to
the new 0.21 schema and try to import those tables
into a fresh 0.21 database.

(This is my first time in my 14 years on the internet
that I am using a mailing list. If I messed up the
reply process, I apologize in advance. I'm replying to
a digest e-mail, but I just put "Re: Watch Recordings
List Empty" as the message subject, hopefully this
will preserve the thread structure somehow.)


      ____________________________________________________________________________________
Be a better friend, newshound, and 
know-it-all with Yahoo! Mobile.  Try it now.  http://mobile.yahoo.com/;_ylt=Ahu06i62sR8HDtDypao8Wcj9tAcJ