If you want painless, then don't upgrade to MySQL 5.X when using
MythTV - the DB schema that MythTV uses has a table with a column
named repeat (I believe, I'm not sitting in front of my Myth box),
which, as of MySQL 5.X, is a reserved word, so the Myth back-end setup
won't be able to create that table, which leads to all sorts of
unpleasant Myth-not-working-ness. You can work around this by
modifying the column name that the table creates/uses (haven't done
this myself, don't know how many Myth places you would need to touch,
so not sure how pain{full,less} that would be, but I have seen reports
of others doing it), or you can just not upgrade to 5.X.Out of curiousity, why are you looking to upgrade MySQL? -James On 11/18/05, Mark Knecht <[EMAIL PROTECTED]> wrote: > Hi, > What are my options? This mysql thing has been hanging out for a > long time. I was scared off by two things: > > 1) I run MythTV which uses mysql. I have a database on my server (this > machine) that I'm worried about losing or messing up. > > 2) I *think* that if I update this server then I have to update all of > my MythTV frontend boxes also as I've heard that Myth required both > the frontend and the backend to run the same versions. > > Does anyone have direct experience with this? I'm sort of worried > about creating problems that take days (or longer) to fix. > > Thanks, > Mark > > dragonfly ~ # cat /etc/portage/package.mask > >x11-drivers/ati-drivers-8.12.10 > #>media-tv/ivtv-0.2.0_rc3-r4 > <=dev-db/mysql-4.1.14 > dragonfly ~ # > > dragonfly ~ # emerge -pv --deep --update mplayer > > These are the packages that I would merge, in order: > > Calculating dependencies / > !!! All ebuilds that could satisfy "dev-db/mysql" have been masked. > !!! One of the following masked packages is required to complete your request: > - dev-db/mysql-4.1.15 (masked by: ~x86 keyword) > - dev-db/mysql-4.1.14 (masked by: package.mask) > - dev-db/mysql-5.0.13_rc (masked by: ~x86 keyword) > - dev-db/mysql-4.1.15-r30 (masked by: -* keyword) > - dev-db/mysql-3.23.58-r1 (masked by: package.mask) > - dev-db/mysql-5.0.15-r30 (masked by: -* keyword) > - dev-db/mysql-4.0.26 (masked by: package.mask, ~x86 keyword) > - dev-db/mysql-4.0.26-r30 (masked by: package.mask, -* keyword) > - dev-db/mysql-5.0.15 (masked by: ~x86 keyword) > - dev-db/mysql-4.0.25-r2 (masked by: package.mask) > > For more information, see MASKED PACKAGES section in the emerge man page or > section 2.2 "Software Availability" in the Gentoo Handbook. > !!! (dependency required by "net-fs/samba-3.0.14a-r2" [ebuild]) > > dragonfly ~ # > > -- > gentoo-user@gentoo.org mailing list > > -- gentoo-user@gentoo.org mailing list
