[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
...
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?
Bill
More information about the mythtv-users
mailing list