From mboxrd@z Thu Jan 1 00:00:00 1970 Received: from pigeon.gentoo.org ([208.92.234.80] helo=lists.gentoo.org) by finch.gentoo.org with esmtp (Exim 4.60) (envelope-from ) id 1Os0Wl-0005xJ-Fe for garchives@archives.gentoo.org; Sat, 04 Sep 2010 21:43:59 +0000 Received: from pigeon.gentoo.org (localhost [127.0.0.1]) by pigeon.gentoo.org (Postfix) with SMTP id CD9F6E0603; Sat, 4 Sep 2010 21:43:04 +0000 (UTC) Received: from www01.badapple.net (www01.badapple.net [64.79.219.163]) by pigeon.gentoo.org (Postfix) with ESMTP id BB3BDE0603 for ; Sat, 4 Sep 2010 21:43:04 +0000 (UTC) Received: from [127.0.0.1] (unknown [76.14.68.122]) (Authenticated sender: ramin@badapple.net) by www01.badapple.net (Postfix) with ESMTPSA id 381DF8446040 for ; Sat, 4 Sep 2010 14:43:04 -0700 (PDT) Message-ID: <4C82BD65.4060501@badapple.net> Date: Sat, 04 Sep 2010 14:43:01 -0700 From: kashani User-Agent: Mozilla/5.0 (Windows; U; Windows NT 6.1; en-US; rv:1.9.2.8) Gecko/20100802 Thunderbird/3.1.2 Precedence: bulk List-Post: List-Help: List-Unsubscribe: List-Subscribe: List-Id: Gentoo Linux mail X-BeenThere: gentoo-user@lists.gentoo.org Reply-to: gentoo-user@lists.gentoo.org MIME-Version: 1.0 To: gentoo-user@lists.gentoo.org Subject: Re: [gentoo-user] Proper way of updating mysql from 5.0.90-r2 to 5.1.50? References: <4C7D3C94.2070602@gmail.com> <201008311931.08748.michaelkintzios@gmail.com> <4C81DEDF.2090408@gmail.com> In-Reply-To: <4C81DEDF.2090408@gmail.com> Content-Type: text/plain; charset=UTF-8; format=flowed Content-Transfer-Encoding: 7bit X-Archives-Salt: 55a6e90c-1ff7-4eab-9c6d-6a7e8565312e X-Archives-Hash: 1f8482e3b86ba5cca56cb73358443f86 On 9/3/2010 10:53 PM, Jarry wrote: > On 31. 8. 2010 20:30, Mick wrote: > >> I stop apach& mysql, run the update, dispatch-conf and then restart them >> both. Haven't had problems since. > > I tried it that way: > > /etc/init.d/apache2 stop > /etc/init.d/mysql stop > emerge --ask --update --deep --newuse world > emerge --depclean > revdep-rebuild > /etc/init.d/mysql start > /etc/init.d/apache2 start > > Still the same: databases are gone, mysql is empty. Only users > are there. This is strange: how can updating mysql from one stable > version to higher stable cause complete loss of databases??? > > Jarry > IIRC the default my.cnf changed for the worse in Gentoo's 5.1.x ebuild. Try making a copy of your original my.cnf and put it into place once you've upgraded. Else you may need to modify the mysql home and data paths in the new my.cnf to reflect where the database are actually installed. kashani