[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