[mythtv-users] Moving the location where my videos are stored...
George Nassas
gnassas at mac.com
Mon Dec 11 02:40:30 UTC 2006
On 10-Dec-06, at 7:37 PM, Jesse Dhillon wrote:
> for filename in `mysql -u mythtvuser -e "select filename from
> mythconverg.videometadata"`; do
> ...
> I wrote that off the top of my head
yikes! How about the following sql:
update videometadata
set filename = insert(filename, 1, length('/old/path'), '/new/path')
where filename like '/old/path%';
the where clause is only necessary if you have more than one tree of
video files - in other words, if your videos path is a colon-
separated list of directories. Most people use only one root.
- George
More information about the mythtv-users
mailing list