[mythtv-users] Changed mythvideo directory - how to rescan vids?

[George Nassas]

On 29-Jul-09, at 8:30 AM, Stephen Hocking wrote:

> for mythvideo and changed the directory from /mythtv/video to /vidoes,
> but it insists on only seeing the 14 or so I used to have, and in the
> old locations as well. How do I tell the system to look for videos in
> the new location?


Rescaning (Utilities -> Videos) will find them but will also drop any  
metadata (titles, cast, covers) you may have added.

To migrate the existing data to the new disk layout you have to go  
into mysql and do something like:

update videometadata
set filename = substr(filename, 8)
where filename like '/mythtv/%';

That will remove the /mythtv from video paths that have it.

Of course, for safety, you should start with a backup:

mysqldump -login credentials mythconverg videometadata >  
videometadata.sql

- George