[mythtv-users] Trying to set up a mythtv-vid frontend, something missing from the database

Alex Halovanic halovanic at gmail.com
Sun Jun 24 04:05:41 UTC 2007


I had to create a new database, let it make the tables from scratch,
backed up the new database, restore my original database, and then
import the extra tables using the lines in the new backup file.
Luckily regular svn doesn't seem to mind the extra tables, so I've
switched back and forth between it and vid occasionally.  Just
remember to save a good backup of the original database anyway, as
mythtv-vid has the potential to screw things up badly at some point.

CREATE TABLE `displayprofilegroups` (
  `name` varchar(128) NOT NULL,
  `hostname` varchar(255) NOT NULL,
  `profilegroupid` int(10) unsigned NOT NULL auto_increment,
  PRIMARY KEY  (`name`,`hostname`),
  UNIQUE KEY `profilegroupid` (`profilegroupid`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

CREATE TABLE `displayprofiles` (
  `profilegroupid` int(10) unsigned NOT NULL,
  `profileid` int(10) unsigned NOT NULL auto_increment,
  `value` varchar(128) NOT NULL,
  `data` varchar(255) NOT NULL default '',
  KEY `profilegroupid` (`profilegroupid`),
  KEY `profileid` (`profileid`,`value`),
  KEY `profileid_2` (`profileid`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;


I think these were the only two tables I added, let me know if you get
some more errors.


More information about the mythtv-users mailing list