[mythtv-users] Missing tables in mythconverg after upgrade to 0.27 on Ubuntu

[Mark Perkins]

> On 27 Oct 2013, at 2:47 am, "Oz Dror" <odror7 at gmail.com> wrote:
> 
> When I try to back up my DB with
> 
>  mythconverg_backup.pl --verbose
> 
> I get:
> 
> mysqldump exited with status: 2
> mysqldump output:
> mysqldump: Got error: 1146: Table 'mythconverg.music_radios' doesn't exist when using LOCK TABLES
> 
> I am actually missing this table.
> 
> Is there a way to restore an empty mythconverg.music_radios so tha I will not have this error any more.
> 
> More generally. I believe that I have a few other corrupt tales in the DB.
> is there an mysql command to restore these tables. Where is the initial DB mysql setup for each table.
> 
> Thanks
> _______________________________________________
> mythtv-users mailing list
> mythtv-users at mythtv.org
> http://www.mythtv.org/mailman/listinfo/mythtv-users

Use optimize_mythdb.pl -> http://www.mythtv.org/wiki/Optimize_mythdb.pl as a start and see what then happens.

Although there may be deeper problems (like a prior failed upgrade) that need input from the experts on the list.

On ubuntu it is located in "/usr/share/doc/mythtv-backend/contrib/maintenance/"
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://www.mythtv.org/pipermail/mythtv-users/attachments/20131027/5973bc98/attachment.html>
-------------- next part --------------
_______________________________________________
mythtv-users mailing list
mythtv-users at mythtv.org
http://www.mythtv.org/mailman/listinfo/mythtv-users