[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