[mythtv-users] suddenly all my recording are gone

[R. G. Newbury]

Tim Shannon wrote:
> You should run the optimize database script just to make sure it's not
> that.  I know that if my mythbox crashes in the middle of recording, it can
> break some tables, and I dont' see any recordings until I run the optimize
> script.
> 
> 
> 
> On Mon, Sep 15, 2008 at 10:21 PM, Claude Gélinas <claude at phyto.qc.ca> wrote:
> 
>> Yesterday as I was trying to view some recording I was faced with an empty
>> recording list in mythfrontend. All recording are on the disk and
>> everything
>> seem to be OK in mysql database.
>>
>> I've two problem:
>>
>> -it look like myth dont get access to the database
>> -I also cannot view live tv (screen turn black few second and come back to
>> myth screen)
>>
>> don't know what to do

Try the tests and suggestions at:

http://www.mythtv.org/docs/mythtv-HOWTO.html#toc22.4

Either the frontend cannot talk to the mysql server, (mysql not running/ 
networking broken) or the server has a problem ( server cannot access 
its temporary folder, or the partition is full etc. etc.)

Check the partition where the mysql database is stored. Check the 
partition where the log files are stored. Under fedora, this is /var in 
both cases. Check the permissions on that partition.


Geoff