No subject

% mysql -u root -p mythconverg

The command you want goes something like this:

update videometadata set filename='/new/filepath' where
filename='/old/filepath';

For bulk moves you may want to collect all your pairs of new/old filepaths
and build a scriptfile with many update commands which you will redirect
into mysql

% mysql -u root -p mythconverg < stuff.sql

Needless to say you need to be careful.  If you are afraid to mess up your
mythconverg database you should probably back it up first.

Also, remember that you have told MythTV to search for files in a particular
directory and if you are moving files to another part of the disk you will
have to tell MythTV about this.

  Gisli


On Sat, May 3, 2008 at 3:27 PM, Johnny Russ <jruss at mit.edu> wrote:

> My children's videos in Mythvideo are getting a little unruly. I would
> like to move the videos into some subfolders to make it more manageable.
> However, I have IMDB data on all of the movies and I have added posters
> for all of the videos. In the past when I have moved a video to a new
> folder it is deleted from the database and then added again in the new
> location. Is there a way to move a video to a new folder without having
> to reenter the metadata?
> _______________________________________________
> mythtv-users mailing list
> mythtv-users at mythtv.org
> http://mythtv.org/cgi-bin/mailman/listinfo/mythtv-users
>

------=_Part_9356_2437525.1209951865785
Content-Type: text/html; charset=ISO-8859-1
Content-Transfer-Encoding: 7bit
Content-Disposition: inline

<br>I would probably just move the files and then fire up the mysql interface and fix the filepaths in the database.<br><br>From a terminal, enter the command <br><br>% mysql -u root -p mythconverg<br><br>The command you want goes something like this:<br>
<br>update videometadata set filename=&#39;/new/filepath&#39; where filename=&#39;/old/filepath&#39;;<br><br>For bulk moves you may want to collect all your pairs of new/old filepaths and build a scriptfile with many update commands which you will redirect into mysql<br>
<br>% mysql -u root -p mythconverg &lt; stuff.sql<br><br>Needless to say you need to be careful.&nbsp; If you are afraid to mess up your mythconverg database you should probably back it up first.<br><br>Also, remember that you have told MythTV to search for files in a particular directory and if you are moving files to another part of the disk you will have to tell MythTV about this.<br>
<br>&nbsp; Gisli<br><br><br><div class="gmail_quote">On Sat, May 3, 2008 at 3:27 PM, Johnny Russ &lt;<a href="mailto:jruss at mit.edu">jruss at mit.edu</a>&gt; wrote:<br><blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;">
My children&#39;s videos in Mythvideo are getting a little unruly. I would<br>
like to move the videos into some subfolders to make it more manageable.<br>
However, I have IMDB data on all of the movies and I have added posters<br>
for all of the videos. In the past when I have moved a video to a new<br>
folder it is deleted from the database and then added again in the new<br>
location. Is there a way to move a video to a new folder without having<br>
to reenter the metadata?<br>
_______________________________________________<br>
mythtv-users mailing list<br>
<a href="mailto:mythtv-users at mythtv.org">mythtv-users at mythtv.org</a><br>
<a href="http://mythtv.org/cgi-bin/mailman/listinfo/mythtv-users" target="_blank">http://mythtv.org/cgi-bin/mailman/listinfo/mythtv-users</a><br>
</blockquote></div><br>

------=_Part_9356_2437525.1209951865785--