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 1OqVcZ-00077I-3i for garchives@archives.gentoo.org; Tue, 31 Aug 2010 18:31:47 +0000 Received: from pigeon.gentoo.org (localhost [127.0.0.1]) by pigeon.gentoo.org (Postfix) with SMTP id 82A0BE0B1A; Tue, 31 Aug 2010 18:31:10 +0000 (UTC) Received: from mail-wy0-f181.google.com (mail-wy0-f181.google.com [74.125.82.181]) by pigeon.gentoo.org (Postfix) with ESMTP id 49E19E0B1A for ; Tue, 31 Aug 2010 18:31:10 +0000 (UTC) Received: by wyf28 with SMTP id 28so9598048wyf.40 for ; Tue, 31 Aug 2010 11:31:09 -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=F7O5eOYz/I7hKcnz5MF0UYJBlywQYuPJjGRdHQBP8zA=; b=PJ+CiGV47UsnbsaCED8cTK0j2jO4voSelTC6OTsIqXTZyyO04dWxsDylcDtSgqYVMg cd6CIqil6bZolRA+Xu61Qfz52EOK0BW3SPWFajl8GWXrWZcQ6wbxOhHzh1Yoho+bp1Pe s4l6ucVtH7rXKdvwDUZTgZJLMlyWR8xlDIilA= 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=w3nAIVpEJuFO5WE5y2x2ANigkc0AQRXcNfSjMRrCpy/lqJZcd6Q57IpxeS5JfIO6nR +M0CSozTzPfuXUJKYAtJyriDZtC7PDPkpb3s8hIuoT+yIeMMvBTvG+OYtDEmnwKieUi2 lP3E8wEZ0a9PkT08mT+Anq83sPyiq6c/fj8V0= Received: by 10.216.74.75 with SMTP id w53mr6693514wed.86.1283279469220; Tue, 31 Aug 2010 11:31:09 -0700 (PDT) Received: from (230.3.169.217.in-addr.arpa [217.169.3.230]) by mx.google.com with ESMTPS id u11sm5496924weq.7.2010.08.31.11.31.07 (version=TLSv1/SSLv3 cipher=RC4-MD5); Tue, 31 Aug 2010 11:31:08 -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: Tue, 31 Aug 2010 19: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> In-Reply-To: <4C7D3C94.2070602@gmail.com> 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="nextPart2801516.N8pnNQzJDA"; protocol="application/pgp-signature"; micalg=pgp-sha1 Content-Transfer-Encoding: 7bit Message-Id: <201008311931.08748.michaelkintzios@gmail.com> X-Archives-Salt: 9083351c-1aa9-4065-bb9e-ea32c525933a X-Archives-Hash: 903e693e06a6eac4c2a77ea5aae6d418 --nextPart2801516.N8pnNQzJDA Content-Type: Text/Plain; charset="utf-8" Content-Transfer-Encoding: quoted-printable On Tuesday 31 August 2010 18:32:04 Jarry wrote: > Hi, > what is the proper way of updating mysql? I did it as with > any other package, following this sequence: >=20 > emerge --ask --update --deep --newuse world > [ebuild N ] net-misc/curl-7.20.0-r2 USE=3D"idn ipv6 ssl -ares -gnutls > -kerberos -ldap -libssh2 -nss -test" > [ebuild N ] dev-util/cmake-2.8.1-r2 USE=3D"ncurses -emacs -qt4 > -vim-syntax" > [ebuild U ] dev-db/mysql-5.1.50 [5.0.90-r2] USE=3D"-pbxt% -xtradb%" > [ebuild U ] virtual/mysql-5.1 [5.0] > emerge --depclean > revdep-rebuild > /etc/init.d/mysqld stop > /etc/init.d/mysqld start >=20 > But this is apparently not the proper way, because after > restarting the server, apache does not show my web-page > reporting there is no such a database. I checked it with > phpmyadmin, and really, there is absolutely no database > in mysql! >=20 > I quickly restored backup version which I have done just > before trying mysql-update, so my web-site is up and running. > Now I would like to update mysql the right way, I but do not > know how to do it... Hi Jarry, Some years ago I ran into some similar problem, I can't recall exactly what= =2E =20 Lost in folklore (wiki?) were some instructions to first stop mysql before = you=20 update it and I have been following them since. I stop apach & mysql, run the update, dispatch-conf and then restart them= =20 both. Haven't had problems since. There may be a better way for doing this - in which case others who know=20 better will hopefully chime in. =2D-=20 Regards, Mick --nextPart2801516.N8pnNQzJDA 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) iEYEABECAAYFAkx9SmwACgkQVTDTR3kpaLZmvQCeNFuQ1hP+ezyaE8E2uoQi8qw7 bYkAoNo0CpWfzNQPQ7aJUkwH2u7f5Yce =nRGG -----END PGP SIGNATURE----- --nextPart2801516.N8pnNQzJDA--