<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<meta content="text/html;charset=ISO-8859-1" http-equiv="Content-Type">
</head>
<body bgcolor="#ffffff" text="#000000">
Udo,<br>
<br>
Sorry I can't help you without your videometadata table, perhaps you
should investigate your mythvideo plugin installation. What distro are
you using and how did you install myth?<br>
<br>
Anyway, here is what you would do if you had such a table:<br>
<br>
#!/usr/bin/env bash<br>
for filename in `mysql -u mythtvuser -e "select filename from
mythconverg.videometadata"`; do<br>
newFilename = `printf "%s" $filename | sed -e
"s#/old/video/path/#/new/video/path/#"`<br>
echo mysql -u mythtvuser -e "update videometadata set
filename=$newFilename where filename=$filename"<br>
done<br>
<br>
I wrote that off the top of my head but that's pretty much what you
need to do. Run that script, and if you're satisfied with the SQL it
generates, remove the echo statement on the third line.<br>
<br>
Jesse.<br>
<br>
<br>
<br>
<br>
<br>
Udo van den Heuvel wrote:
<blockquote cite="mid457BE135.6010706@xs4all.nl" type="cite">
<pre wrap="">Jesse Dhillon wrote:
</pre>
<blockquote type="cite">
<blockquote type="cite">
<pre wrap="">Hmmm. Table 'mythconverg.videometadata' doesn't exist.
Also the settings table has teh path to the recorded videos.
I am at 0.21something. Is stuff different in that version
</pre>
</blockquote>
<pre wrap="">I don't know what the schema looks like in 0.21, since I am running
0.20. You can use "show databases;" and "show tables;" to poke around
and see where your video metadata is stored. If you want, maybe paste
the results and I or someone can maybe help you.
</pre>
</blockquote>
<pre wrap=""><!---->
Results are below.
I also found some info about exporting/importing certain parts of the
database, running myth-setup, and importing the database exports again.
I only see the path in the settings table but changing that entry makes
MythTV look for strange names (/newpath/bla.mpeg/bla.mpeg).
Kind regards,
Udo
mysql> show tables;
+--------------------------------+
| Tables_in_mythconverg |
+--------------------------------+
| callsignnetworkmap |
| capturecard |
| cardinput |
| channel |
| codecparams |
| credits |
| customexample |
| diseqc_config |
| diseqc_tree |
| dtv_multiplex |
| dtv_privatetypes |
| dvdbookmark |
| dvdinput |
| dvdtranscode |
| eit_cache |
| favorites |
| housekeeping |
| inuseprograms |
| jobqueue |
| jumppoints |
| keybindings |
| keyword |
| music_albums |
| music_artists |
| music_genres |
| music_playlists |
| music_smartplaylist_categories |
| music_smartplaylist_items |
| music_smartplaylists |
| music_songs |
| music_stats |
| musicmetadata |
| musicplaylist |
| mythlog |
| mythweb_sessions |
| networkiconmap |
| oldfind |
| oldprogram |
| oldrecorded |
| people |
| pidcache |
| playgroup |
| profilegroups |
| program |
| programgenres |
| programrating |
| recgrouppassword |
| record |
| recorded |
| recordedcredits |
| recordedmarkup |
| recordedprogram |
| recordedrating |
| recordedseek |
| recordingprofiles |
| recordmatch |
| schemalock |
| settings |
| storagegroup |
| tvchain |
| videobookmarks |
| videosource |
+--------------------------------+
62 rows in set (0.01 sec)
_______________________________________________
mythtv-users mailing list
<a class="moz-txt-link-abbreviated" href="mailto:mythtv-users@mythtv.org">mythtv-users@mythtv.org</a>
<a class="moz-txt-link-freetext" href="http://mythtv.org/cgi-bin/mailman/listinfo/mythtv-users">http://mythtv.org/cgi-bin/mailman/listinfo/mythtv-users</a>
</pre>
</blockquote>
</body>
</html>