[mythtv-users] major db problem upgrading from 0.21-fixes to 0.22

[Dale Pontius]

Michael T. Dean wrote:
> On 03/07/2010 05:30 AM, Audio Phile wrote:
>> Thank you both for the advice.
>> @mtdean - I attempted your procedure
>> (http://www.gossamer-threads.com/lists/mythtv/users/406111#406111) but
>> ran into trouble:
>>
>> I can drop the db okay but I couldn't use your code with the echo<< 
>> "EOF",
> 
> You almost definitely had something (like a space) after the EOF (bad
> copy/paste).
> 
>> I can restore the blank one okay:
>> [mythtv at mythtv ~]$ /usr/share/mythtv/mythconverg_restore.pl
>> --dir=$HOME --file=mythconverg-1214-blank.sql.gz --verbose
>>    
> ...
>> Successfully restored backup.
>>
>> But I can't restore my backup:
>>
>> [mythtv at mythtv ~]$ /usr/share/mythtv/mythconverg_restore.pl
>> --dir=$HOME --file=mythconverg-1215-20100306190349.sql.gz --verbose
>>    
> 
> [Look closely at the above.  What's missing?] ...
> 
>> Found 54 tables in the database.
>> WARNING: Database not empty.
>>
>> ERROR: Unable to do a *full* restore. The database contains data.
>>    
> 
> [emphasis added]
> 
> Hmmm...  Unable to do a *full* restore because the database is not
> empty.  What were we trying to do?
> 
>> Can you advise?
>>    
> 
> Re-read the 2 sets of instrucitons you were given (my e-mail and
> http://www.mythtv.org/wiki/Fixing_Corrupt_Database_Encoding#Partial_vs_.22equal.22_corruption
> ).  You're doing something wrong

The instructions at
http://www.gossamer-threads.com/lists/mythtv/users/406111#406111
are missing the "--partial_restore" flag on step 4.  That fact gets
picked up by reading the
http://www.mythtv.org/wiki/Fixing_Corrupt_Database_Encoding#Partial_vs_.22equal.22_corruption
link, then following the "partial restore" link on that page.

In other words, it takes a bit more careful reading than it would if the
flag weren't missing from the first reference.  It also takes realizing
that there is an omission on the first reference.  Figuring that out was
what it took to get my database migrated.

Dale Pontius
> 
> Mike "I can write the instructions, but I don't want to also have to
> read them to you" Dean
> _______________________________________________
> mythtv-users mailing list
> mythtv-users at mythtv.org
> http://mythtv.org/cgi-bin/mailman/listinfo/mythtv-users