[mythtv-users] No current database version?

[Jongi]

On Sat, 2010-02-20 at 12:46 +0200, Jongi wrote:

> On Fri, 2010-02-19 at 18:17 -0500, R. G. Newbury wrote: 
> 
> > You have a missing ' needed to match the one at the beginning of 
> > '/mnt/mythtv/media/mythconverg--2010021912721.sql
> > 
> > 
> > Geoff
> > 
> > 
> > 
> 
> It seems the proverbial has been hit
> 
> $ mysqldump --host='192.168.1.102' --user='mythtv' --add-drop-table
> --add-locks --allow-keywords --complete-insert --extended-insert
> --lock-tables --no-create-db -p --quick 'mythconverg' >
> '/mnt/mythtv/media/mythconverg--20100219212721.sql'                                                                          
> Enter
> password:                                                                                                 
> mysqldump: Got error: 144: Table './mythconverg/settings' is marked as
> crashed and last (automatic?) repair failed when using LOCK TABLES 
> 

Did some google searching which led to do the below:

$ /opt/mythtv-0-22/mythtv/contrib/maintenance/optimize_mythdb.pl
DBD::mysql::st execute failed: Table './mythconverg/settings' is marked
as crashed and last (automatic?) repair failed
at /usr/local/share/perl/5.10.1/MythTV.pm line 404.
DBD::mysql::st fetchrow_array failed: fetch() without execute()
at /usr/local/share/perl/5.10.1/MythTV.pm line 405.
DBD::mysql::st execute failed: Table './mythconverg/settings' is marked
as crashed and last (automatic?) repair failed
at /usr/local/share/perl/5.10.1/MythTV.pm line 404.
DBD::mysql::st fetchrow_array failed: fetch() without execute()
at /usr/local/share/perl/5.10.1/MythTV.pm line 405.
MasterServerIP or MasterServerPort not found!
You may need to check your settings.php file or re-run mythtv-setup.

Thinking I had isolated the problem I tried to locate the settings.php
file, however that wasn't as straightforward as i had hoped

$ locate
settings.php                                                                            
/opt/mythtv-0-22/mythplugins/mythweb/modules/database/set_settings.php                                          
/opt/mythtv-0-22/mythplugins/mythweb/modules/database/.svn/prop-base/set_settings.php.svn-base                  
/opt/mythtv-0-22/mythplugins/mythweb/modules/database/.svn/text-base/set_settings.php.svn-base                  
/opt/mythtv-0-22/mythplugins/mythweb/modules/database/tmpl/default/set_settings.php                             
/opt/mythtv-0-22/mythplugins/mythweb/modules/database/tmpl/default/.svn/prop-base/set_settings.php.svn-base     
/opt/mythtv-0-22/mythplugins/mythweb/modules/database/tmpl/default/.svn/text-base/set_settings.php.svn-base     
/opt/mythtv-0-22/mythplugins/mythweb/modules/mythtv/set_settings.php                                            
/opt/mythtv-0-22/mythplugins/mythweb/modules/mythtv/.svn/prop-base/set_settings.php.svn-base                    
/opt/mythtv-0-22/mythplugins/mythweb/modules/mythtv/.svn/text-base/set_settings.php.svn-base                    
/opt/mythtv-0-22/mythplugins/mythweb/modules/mythtv/tmpl/default/set_settings.php                               
/opt/mythtv-0-22/mythplugins/mythweb/modules/mythtv/tmpl/default/.svn/prop-base/set_settings.php.svn-base       
/opt/mythtv-0-22/mythplugins/mythweb/modules/mythtv/tmpl/default/.svn/text-base/set_settings.php.svn-base       
/opt/mythtv-0-22/mythplugins/mythweb/modules/mythtv/tmpl/lite/set_settings.php                                  
/opt/mythtv-0-22/mythplugins/mythweb/modules/mythtv/tmpl/lite/.svn/prop-base/set_settings.php.svn-base          
/opt/mythtv-0-22/mythplugins/mythweb/modules/mythtv/tmpl/lite/.svn/text-base/set_settings.php.svn-base          
/opt/mythtv-0-22/mythplugins/mythweb/modules/video/set_settings.php                                             
/opt/mythtv-0-22/mythplugins/mythweb/modules/video/.svn/prop-base/set_settings.php.svn-base                     
/opt/mythtv-0-22/mythplugins/mythweb/modules/video/.svn/text-base/set_settings.php.svn-base                     
/opt/mythtv-0-22/mythplugins/mythweb/modules/video/tmpl/default/set_settings.php                                
/opt/mythtv-0-22/mythplugins/mythweb/modules/video/tmpl/default/.svn/prop-base/set_settings.php.svn-base        
/opt/mythtv-0-22/mythplugins/mythweb/modules/video/tmpl/default/.svn/text-base/set_settings.php.svn-base        
/var/www/mythweb/modules/database/set_settings.php                                                              
/var/www/mythweb/modules/database/.svn/prop-base/set_settings.php.svn-base                                      
/var/www/mythweb/modules/database/.svn/text-base/set_settings.php.svn-base                                      
/var/www/mythweb/modules/database/tmpl/default/set_settings.php
/var/www/mythweb/modules/database/tmpl/default/.svn/prop-base/set_settings.php.svn-base
/var/www/mythweb/modules/database/tmpl/default/.svn/text-base/set_settings.php.svn-base
/var/www/mythweb/modules/mythtv/set_settings.php
/var/www/mythweb/modules/mythtv/.svn/prop-base/set_settings.php.svn-base
/var/www/mythweb/modules/mythtv/.svn/text-base/set_settings.php.svn-base
/var/www/mythweb/modules/mythtv/tmpl/default/set_settings.php
/var/www/mythweb/modules/mythtv/tmpl/default/.svn/prop-base/set_settings.php.svn-base
/var/www/mythweb/modules/mythtv/tmpl/default/.svn/text-base/set_settings.php.svn-base
/var/www/mythweb/modules/mythtv/tmpl/lite/set_settings.php
/var/www/mythweb/modules/mythtv/tmpl/lite/.svn/prop-base/set_settings.php.svn-base
/var/www/mythweb/modules/mythtv/tmpl/lite/.svn/text-base/set_settings.php.svn-base
/var/www/mythweb/modules/video/set_settings.php
/var/www/mythweb/modules/video/.svn/prop-base/set_settings.php.svn-base
/var/www/mythweb/modules/video/.svn/text-base/set_settings.php.svn-base
/var/www/mythweb/modules/video/tmpl/default/set_settings.php
/var/www/mythweb/modules/video/tmpl/default/.svn/prop-base/set_settings.php.svn-base
/var/www/mythweb/modules/video/tmpl/default/.svn/text-base/set_settings.php.svn-base
/var/www/zussaweb/settings.php

Regards
Jongi
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://mythtv.org/pipermail/mythtv-users/attachments/20100220/ead3b4be/attachment-0001.htm>