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

[Michael T. Dean]

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

Mike "I can write the instructions, but I don't want to also have to 
read them to you" Dean