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 1Os1HP-0002YM-Uc for garchives@archives.gentoo.org; Sat, 04 Sep 2010 22:32:12 +0000 Received: from pigeon.gentoo.org (localhost [127.0.0.1]) by pigeon.gentoo.org (Postfix) with SMTP id 2F4E1E058E; Sat, 4 Sep 2010 22:31:28 +0000 (UTC) Received: from mail-ww0-f53.google.com (mail-ww0-f53.google.com [74.125.82.53]) by pigeon.gentoo.org (Postfix) with ESMTP id E6E77E058E for ; Sat, 4 Sep 2010 22:31:27 +0000 (UTC) Received: by wwf26 with SMTP id 26so3754728wwf.10 for ; Sat, 04 Sep 2010 15:31:27 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=gamma; h=domainkey-signature:received:received:from:reply-to:to:subject:date :user-agent:references:in-reply-to:mime-version:content-type :content-transfer-encoding:message-id; bh=1miNfXCnI/QfGavvXlOGSo7YbKawtt5WZsgLHHcX+2s=; b=vLMokhcDr7qBI9WSG1j/X2Nnbr6CzrEDvrRUw1/uw8uFj2+gvuuLV8fQE0yJPI/O06 7z62r9aBiFERT/fF7San/vh9xChYJX5c2RElTN2vTiGFcNRn7qfKeOvww5b2FL4itA96 5BzleWHnbIf4oBzPsQubWTav0JrjfFI0x2rsg= DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=gamma; h=from:reply-to:to:subject:date:user-agent:references:in-reply-to :mime-version:content-type:content-transfer-encoding:message-id; b=N1/zzKf8zGWV1lrXPnS0SCb0Um8zaNqhQb0nkkot084j3G9ev+/a+jchuo2pDUdzMS Ci+bEcVufSp/un8DBVTuS4sEGSJbRPHefDstWOqwnJO33oHeDgQp6kSCM77bcCjnQYWU zJ7byMGuDkxZEs0srSQoS4PDhx6tMHNDBRNNU= Received: by 10.227.141.141 with SMTP id m13mr435980wbu.152.1283639487328; Sat, 04 Sep 2010 15:31:27 -0700 (PDT) Received: from (230.3.169.217.in-addr.arpa [217.169.3.230]) by mx.google.com with ESMTPS id e31sm3017954wbe.5.2010.09.04.15.31.25 (version=TLSv1/SSLv3 cipher=RC4-MD5); Sat, 04 Sep 2010 15:31:26 -0700 (PDT) From: Mick To: gentoo-user@lists.gentoo.org Subject: Re: [gentoo-user] Proper way of updating mysql from 5.0.90-r2 to 5.1.50? Date: Sat, 4 Sep 2010 23:30:55 +0100 User-Agent: KMail/1.13.5 (Linux/2.6.34-gentoo-r6; KDE/4.4.5; x86_64; ; ) References: <4C7D3C94.2070602@gmail.com> <4C81DEDF.2090408@gmail.com> <4C82BD65.4060501@badapple.net> In-Reply-To: <4C82BD65.4060501@badapple.net> 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 Content-Type: multipart/signed; boundary="nextPart10363755.IHCOdb3vDa"; protocol="application/pgp-signature"; micalg=pgp-sha1 Content-Transfer-Encoding: 7bit Message-Id: <201009042331.25204.michaelkintzios@gmail.com> X-Archives-Salt: de656e95-0bc0-4ea9-82c8-d000f84cf368 X-Archives-Hash: 807b96f61c2c6432f245e948b1e185ea --nextPart10363755.IHCOdb3vDa Content-Type: Text/Plain; charset="utf-8" Content-Transfer-Encoding: quoted-printable On Saturday 04 September 2010 22:43:01 kashani wrote: > 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 th= em > >> both. Haven't had problems since. > >=20 > > I tried it that way: > >=20 > > /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 > >=20 > > 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??? > >=20 > > Jarry >=20 > 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. I just updated to mysql-5.1.50-r1 on a x86 box, ran revdep-rebuild which=20 amidst others rebuilt apache and php and all is good now. dispatch-conf=20 updated only a couple of lines on the config file. The default paths were not affected on any of the 5 mysql databases I'm=20 running currently. =2D-=20 Regards, Mick --nextPart10363755.IHCOdb3vDa Content-Type: application/pgp-signature; name=signature.asc Content-Description: This is a digitally signed message part. -----BEGIN PGP SIGNATURE----- Version: GnuPG v2.0.16 (GNU/Linux) iEYEABECAAYFAkyCyL0ACgkQVTDTR3kpaLYjcACdFVJl3NPoyJ4k1bZSu1QtGXpZ P1wAn2ZLzWVWCVVHB6t0nnpl7563etys =YtL9 -----END PGP SIGNATURE----- --nextPart10363755.IHCOdb3vDa--