From mboxrd@z Thu Jan 1 00:00:00 1970 Received: from lists.gentoo.org ([140.105.134.102] helo=robin.gentoo.org) by nuthatch.gentoo.org with esmtp (Exim 4.50) id 1EdLlo-0007LH-Iy for garchives@archives.gentoo.org; Sat, 19 Nov 2005 06:00:16 +0000 Received: from robin.gentoo.org (localhost [127.0.0.1]) by robin.gentoo.org (8.13.5/8.13.5) with SMTP id jAJ5vstn008790; Sat, 19 Nov 2005 05:57:54 GMT Received: from mail.pnpitalia.it (85-18-21-122.ip.fastwebnet.it [85.18.21.122]) by robin.gentoo.org (8.13.5/8.13.5) with ESMTP id jAJ5qHIi031681 for ; Sat, 19 Nov 2005 05:52:17 GMT Received: from localhost (localhost [127.0.0.1]) by mail.pnpitalia.it (Postfix) with ESMTP id ED98A7AD6F8 for ; Sat, 19 Nov 2005 06:52:16 +0100 (CET) Received: from mail.pnpitalia.it ([127.0.0.1]) by localhost (db [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id 28437-04 for ; Sat, 19 Nov 2005 06:52:16 +0100 (CET) Received: from host-4-153.pnpitalia.it (host-4-153.pnpitalia.it [192.168.4.153]) by mail.pnpitalia.it (Postfix) with ESMTP id 60F8F7AD6F6 for ; Sat, 19 Nov 2005 06:52:16 +0100 (CET) From: "Francesco R." Organization: PNP Italia To: gentoo-user@lists.gentoo.org Subject: Re: [gentoo-user] mysql update questions Date: Sat, 19 Nov 2005 06:52:16 +0100 User-Agent: KMail/1.9 References: <5bdc1c8b0511181622p14077fc3i1bb2cc2799832968@mail.gmail.com> In-Reply-To: <5bdc1c8b0511181622p14077fc3i1bb2cc2799832968@mail.gmail.com> Precedence: bulk List-Post: List-Help: List-Unsubscribe: List-Subscribe: List-Id: Gentoo Linux mail X-BeenThere: gentoo-user@gentoo.org Reply-to: gentoo-user@lists.gentoo.org MIME-Version: 1.0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: 7bit Content-Disposition: inline Message-Id: <200511190652.16081.vivo@gentoo.org> X-Virus-Scanned: amavisd-new at db X-Archives-Salt: 989fe800-80fd-4190-9942-6e3762d2a1f8 X-Archives-Hash: 8b271cd27315adf4fd4a47896838c990 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