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

Bill Meek keemllib at gmail.com
Fri Oct 7 20:20:47 UTC 2011

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


 From MySQL, try: show databases;

Expect to see 2:


Then from your shell, sudo -i

   cd /var/lib/mysql/mythconverg
   ls weather*

Expect 3:

   weatherdatalayout.frm  weatherscreens.frm  weathersourcesettings.frm

Could there be an errant mythconverg subdirectory?


More information about the mythtv-users mailing list