[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