[mythtv-users] dd_v_ tables missing from mythconverg

R. G. Newbury newbury at mandamus.org
Fri Nov 16 15:41:45 UTC 2007


Michael T. Dean wrote:
>> Thanks for the idea, however. I will try the straight schema change, but 
>> I suspect that it is a non-starter, although why is another question. 
>> Then it's off for the backup route. Only 7 days of listings data 
>> available at present.
> 
> $ grep "INSERT INTO settings " mythtv_backup.sql >> restore.sql
> 
> etc... to carry over as much or as little garbage as you desire from
> your currently broken DB.

Actually I just dumped the settings table to a separate file, and when I 
get the permissions fiasco figured out, I will diff the old one against 
the new one, to see what changed and what I need to change.

But as noted in my new message, there is something more basis going on, 
that mythtv or mysql does not have permission to create temporary 
tables. And the 'right' places are owned by mysql and perm'ed as 
775....so this is totally weird.

Geoff






More information about the mythtv-users mailing list