[mythtv-users] database problems, primary and index keys.

Khanh Tran khanh at khanh.net
Thu Apr 12 12:33:03 UTC 2007


>
> My recommendation is:
> http://mythtv.org/docs/mythtv-HOWTO-23.html#ss23.5 then
> http://mythtv.org/docs/mythtv-HOWTO-23.html#ss23.6 then
> http://mythtv.org/docs/mythtv-HOWTO-6.html#ss6.2 then
> http://mythtv.org/docs/mythtv-HOWTO-23.html#ss23.7
>
> Anything else is likely to cause problems and leave a lot of garbage
> (which is probably causing the issues) on your system.  The above is the
> MythTV MySQL Database equivalent of "format c:" followed by a fresh
> Windows install (only difference is one of the two should only be
> required for one user in 10000 (est) and the other is required for all
> users once every year--but preferrably once every 6 months).

I did http://mythtv.org/docs/mythtv-HOWTO-6.html#ss6.2 on a new
install of MySQL elsewhere and after running mythtv-setup to bring the
schema up, I still get the same errors (without the `videometadata`
table).  Perhaps this is "normal"?


More information about the mythtv-users mailing list