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

Mark Boyum mark at boyum.us
Fri Oct 7 20:49:46 UTC 2011


On Fri, Oct 7, 2011 at 3:20 PM, Bill Meek <keemllib at gmail.com> wrote:
> On 10/07/2011 02:16 PM, 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:
> ...
>> 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
> ...
>
> Hi;
>
>  From MySQL, try: show databases;
>
> Expect to see 2:
>
>   information_schema
>   mythconverg
>
> Then from your shell, sudo -i
>
>   cd /var/lib/mysql/mythconverg
>   ls weather*
>   control-d
>
> Expect 3:
>
>   weatherdatalayout.frm  weatherscreens.frm  weathersourcesettings.frm
>
> Could there be an errant mythconverg subdirectory?
>

Contents of /var/lib/mysql:
debian-5.1.flag  ib_logfile0  mysql               mythconverg
ibdata1          ib_logfile1  mysql_upgrade_info  mythtv.pid

As expected, ls weather* returns those three files.


More information about the mythtv-users mailing list