[mythtv-users] How do I update file size after manually transcoding?

[Rod Emerson]

Yeechang Lee wrote:
> 
> I understand that. Now, how do I update said field in the database?
> 

Show recorded title, starttime and filesize :

$ mysql -umythtv -pmythtv mythconverg -e \
  "SELECT title,chanid,starttime,filesize FROM recorded;"

+-------------+--------+---------------------+------------+
| title       | chanid | starttime           | filesize   |
+-------------+--------+---------------------+------------+
| Whatever    |   1502 | 2006-08-03 11:55:00 | 3868366852 |


Change "filesize" of a recorded program :

$ mysql -umythtv -pmythtv mythconverg -e \
  "UPDATE recorded SET lastmodified = 'NOW()', filesize = '200' \
  WHERE chanid = '1502' AND starttime = '2006-08-03 11:55:00';"

$ mysql -umythtv -pmythtv mythconverg -e \
  "SELECT title,chanid,starttime,filesize FROM recorded;"

+-------------+--------+---------------------+------------+
| title       | chanid | starttime           | filesize   |
+-------------+--------+---------------------+------------+
| Whatever    |   1502 | 2006-08-03 11:55:00 |        200 |