[mythtvnz] Corrupt database?

[Paulgir]

On Wed, 23 Jan 2013 22:28:05 +1300, tortise <tortise at paradise.net.nz>  
wrote:

> On 23/01/2013 8:48 p.m., Nick Rout wrote:
>>
>>
>> On Wed, Jan 23, 2013 at 8:35 PM, Paulgir <paulgir at gmail.com
>> <mailto:paulgir at gmail.com>> wrote:
>>
>>
>>     When I checked Mythtv (Mythbuntu)today I found it showing a language
>>     set up window that I had not seen before.I closed this window and
>>     was on the xfce desktop,I tried to start Myth frontend or
>>     mythbackend setup it reverts to the language set-up window.
>>     I tried to do a database restore but I get this message:
>>
>>
>> What makes you think there is a database problem. Check systematically  
>> that:
>>
>> 1. mysql is running on the backend
>> 2. mythbackend ditto
>> 3. you have network connectivity to the backend.
>> 4. whether there are any crashed database tables that need repair. HINT
>> if you are on mythbuntu run /etc/cron.weekly/mythtv-database
>> 5. whether your ~/.mythtv/mysql.txt and ~/.mythtv/config.xml files have
>> the right info.
>> 6. Look, yes look, at the logging file - particularly
>> /var/log/mythtv/mythfrontend.log, or start mythfrontend from the command
>> line and read the output.
>>
>>
>
> /mythweb/settings/database may also be helpful if you are not aware of  
> it?
>
> _______________________________________________
> mythtvnz mailing list
> mythtvnz at lists.linuxnut.co.nz
> http://lists.ourshack.com/mailman/listinfo/mythtvnz
> Archives http://www.gossamer-threads.com/lists/mythtv/mythtvnz/

As I mentioned,earlier,I got the following message when I tried to restore  
the db;

Found 105 tables in the database.
WARNING: Database not empty.

So I added the --drop_database --create_database arguments to the restore  
command and the restore was successful and mythtv seems to be running  
normally.

Couldn't find /mythweb/settings/database. Does mythweb need to be  
installed independently of the mythbuntu distro?

cheers

Paul