<html><head><meta http-equiv="content-type" content="text/html; charset=utf-8"></head><body dir="auto"><div><br></div><div>On 27 Oct 2013, at 2:47 am, "Oz Dror" <<a href="mailto:odror7@gmail.com">odror7@gmail.com</a>> wrote:<br><br></div><blockquote type="cite"><div><div dir="ltr">When I try to back up my DB with<div><br><div><div> <a href="http://mythconverg_backup.pl">mythconverg_backup.pl</a> --verbose</div></div><div><br></div><div>I get:</div></div><div><br></div><div><div>mysqldump exited with status: 2</div>
<div>mysqldump output:</div><div>mysqldump: Got error: 1146: Table 'mythconverg.music_radios' doesn't exist when using LOCK TABLES</div></div><div><br></div><div>I am actually missing this table.</div><div><br>
</div><div>Is there a way to restore an empty mythconverg.music_radios so tha I will not have this error any more.</div><div><br></div><div>More generally. I believe that I have a few other corrupt tales in the DB.</div>
<div>
is there an mysql command to restore these tables. Where is the initial DB mysql setup for each table.</div><div><br></div><div>Thanks</div></div>
</div></blockquote><blockquote type="cite"><div><span>_______________________________________________</span><br><span>mythtv-users mailing list</span><br><span><a href="mailto:mythtv-users@mythtv.org">mythtv-users@mythtv.org</a></span><br><span><a href="http://www.mythtv.org/mailman/listinfo/mythtv-users">http://www.mythtv.org/mailman/listinfo/mythtv-users</a></span><br></div></blockquote><br><div>Use optimize_mythdb.pl -> <a href="http://www.mythtv.org/wiki/Optimize_mythdb.pl">http://www.mythtv.org/wiki/Optimize_mythdb.pl</a> as a start and see what then happens.</div><div><br></div><div>Although there may be deeper problems (like a prior failed upgrade) that need input from the experts on the list.</div><div><br></div><div>On ubuntu it is located in "/usr/share/doc/mythtv-backend/contrib/maintenance/"</div></body></html>