[gentoo-user] mysql update questions

[gentoo-user] mysql update questions

[Mark Knecht]

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

Re: [gentoo-user] mysql update questions

[Francesco R.]

Alle 01:22, sabato 19 novembre 2005, Mark Knecht el ga butta:
> |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.

Backup as described in 
"http://www.gentoo.org/doc/en/mysql-upgrading.xml" 
replace "revdep-rebuild" with 
"revdep-rebuild --soname=libmysqlclient.so.12"

grep the ebuild for "einfo" or follow them during emerge

> |
> |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.

Maybe the following options (put them in my.cnf of the server) help
  
#Use old password encryption method (needed for 4.0 and
#older clients).
old-passwords   

#Disallow authentication for accounts that have old
# (pre-4.1) passwords.
secure-auth       

Don't switch collation and charachter set to utf8

http://forums.gentoo.org/viewtopic-t-399371-highlight-mysql.html

> |
> |   Does anyone have direct experience with this? I'm sort of worried
> |about creating problems that take days (or longer) to fix.
> |
Sorry not me 
[...]

A bit too short answer but it's very late in the morning here ...
good night
-- 
gentoo-user@gentoo.org mailing list

Re: [gentoo-user] mysql update questions

[James Ausmus]

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 <markknecht@gmail.com> 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