[mythtv-users] Moving the location where my videos are stored...

Udo van den Heuvel udovdh at xs4all.nl
Sun Dec 10 10:28:05 UTC 2006


Jesse Dhillon wrote:
>> 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
> 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.

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)



More information about the mythtv-users mailing list