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 1EeIUd-00044b-GF for garchives@archives.gentoo.org; Mon, 21 Nov 2005 20:42:27 +0000 Received: from robin.gentoo.org (localhost [127.0.0.1]) by robin.gentoo.org (8.13.5/8.13.5) with SMTP id jALKcwwf027432; Mon, 21 Nov 2005 20:38:58 GMT Received: from wproxy.gmail.com (wproxy.gmail.com [64.233.184.206]) by robin.gentoo.org (8.13.5/8.13.5) with ESMTP id jALKP0Di020711 for ; Mon, 21 Nov 2005 20:25:00 GMT Received: by wproxy.gmail.com with SMTP id 69so995579wri for ; Mon, 21 Nov 2005 12:24:59 -0800 (PST) DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=beta; d=gmail.com; h=received:message-id:date:from:to:subject:in-reply-to:mime-version:content-type:content-transfer-encoding:content-disposition:references; b=JxowPMNnBzprGk/2MESYlEt7Gxae0nfqZC6hl6cJ669sJ/jLzwtIzaj9LToVlM56cR8n50/nDmO+f1EIj1fUh93aNs8BuBxSqdJWpSz3RO98pLYGuntY0kyDKWLWwwu3Z6J60nZKTJOZNuHQENrLnYxTNOKRZ1MBTk8H9nDtVnE= Received: by 10.54.138.13 with SMTP id l13mr1443733wrd; Mon, 21 Nov 2005 10:28:37 -0800 (PST) Received: by 10.54.150.18 with HTTP; Mon, 21 Nov 2005 10:28:37 -0800 (PST) Message-ID: Date: Mon, 21 Nov 2005 10:28:37 -0800 From: James Ausmus To: gentoo-user@lists.gentoo.org, Mark Knecht Subject: Re: [gentoo-user] mysql update questions 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-Disposition: inline References: <5bdc1c8b0511181622p14077fc3i1bb2cc2799832968@mail.gmail.com> Content-Transfer-Encoding: 8bit X-MIME-Autoconverted: from quoted-printable to 8bit by robin.gentoo.org id jALKP0Di020711 X-Archives-Salt: e8f61e7a-1386-491c-a5ff-24e866f1d0f1 X-Archives-Hash: b8b144eb88d4cf8c1e0a28809bd192af 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 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