[mythtv-users] mythconverg_backup.pl choking on mythweather tables

Raymond Wagner raymond at wagnerrp.com
Fri Oct 7 20:05:47 UTC 2011


On 10/7/2011 15:16, Mark Boyum wrote:
> On Fri, Oct 7, 2011 at 1:38 PM, Raymond Wagner<raymond at wagnerrp.com>  wrote:
>> On 10/7/2011 14:33, Mark Boyum wrote:
>>> mysqldump: Got error: 1146: Table
>>> 'mythconverg.mythconverg.weatherscreens' doesn't exist when using LOCK
>>> TABLES
>> That's not a table MythWeather uses for anything.  It sounds like some
>> external utility got confused and created a bad table.
> So I tried to drop that table and get this:
>
> mysql>  drop table mythconverg.weatherscreens;
> ERROR 1217 (23000): Cannot delete or update a parent row: a foreign
> key constraint fails

To be honest, I'm not entirely certain how you got a table with a period 
in the name in the first place, much less how to remove it.


More information about the mythtv-users mailing list