Re: [gentoo-user] mysql update questions

["Francesco R." <vivo@gentoo.org>]

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