[mythtv-users] dd_v_ tables missing from mythconverg

[Michael T. Dean]

On 11/12/2007 10:10 PM, R. G. Newbury wrote:
> Michael T. Dean wrote:
>   
>> the MythTV "Spring Cleaning" (TM): 
>> http://mythtv.org/docs/mythtv-HOWTO-23.html#ss23.7
>>     
> Mike you have to go to a meeting. In the meantime, repeat after me: 'I'm 
> Mike and I am an addict. I am addicted to telling everyone to delete all 
> their cards from the database and then recreate them'.
>
> Cause of course, that's what the 'Spring Cleaning' (MM  Mike's Mark!) 
> results in.!!
>
> But yes, that would be one way of forcing a schema upgrade. However, it 
> would be a little faster to just use the --tables switch in mysqldump to 
> back up the desired tables. The real killer being, of course, that I 
> would lose all the particular settings which let my box play HD without 
> xvmc (not available for Intel 945G and exceedingly dependent upon a 
> couple of switches being exactly right)
> .....A little more work required to create a separate 'settings' table 
> dump and to diff it and edit it, I guess...
>
> 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.

Mike