[mythtv-users] Mythtv 0.22 upgrade problems

Michael T. Dean mtdean at thirdcontact.com
Sat Nov 14 19:06:57 UTC 2009


On 11/14/2009 02:01 PM, Michael T. Dean wrote:
> The following will capture the output in a file called results.log in 
> the user's home directory:

er, the current directory...

>
> cat << "EOF" | mysql -umythtv -p mythconverg 2>&1 | tee results.log
> DROP TABLE IF EXISTS videocast;
> DROP TABLE IF EXISTS videocategory;
> DROP TABLE IF EXISTS videocountry;
> DROP TABLE IF EXISTS videogenre;
> DROP TABLE IF EXISTS videometadata;
> DROP TABLE IF EXISTS videometadatacast;
> DROP TABLE IF EXISTS videometadatacountry;
> DROP TABLE IF EXISTS videometadatagenre;
> DROP TABLE IF EXISTS videotypes;
> DROP TABLE IF EXISTS filemarkup;
> DROP TABLE IF EXISTS dvdinput;
> DROP TABLE IF EXISTS dvdtranscode;
> DELETE FROM settings WHERE value
>  IN ('mythvideo.DBSchemaVer',
>      'VideoDBSchemaVer',
>      'DVDDBSchemaVer');
> EOF 

To put it in the user's home directory, change the command to include 
$HOME/results.log .  (I forgot to do that before sending.)

Mike


More information about the mythtv-users mailing list