[mythtv-users] nuvexport; option missing

Robert Johnston anaerin at gmail.com
Mon Jan 8 05:51:50 UTC 2007


On 1/7/07, devsk <funtoos at yahoo.com> wrote:
>
> #!/bin/bash
> nuvexport --infile $1
> filen=`basename $1`
> nfilen=${filen/.mpg/.avi}
> echo "update recorded where basename='$filen' set basename='$nfilen' ;" |
> mysql -umythtv -pmythtv -Dmythconverg
>
> I am just geussing on the sql syntax here but it should be close enough (if
> someone can correct it, please do). Would this work?

Apart from the set and where being in the wrong order (update recorded
set basename='$nfilen' where basename='$filen';) that looks good to
me.
-- 
Robert "Anaerin" Johnston


More information about the mythtv-users mailing list