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 1OsCA7-00081m-DM for garchives@archives.gentoo.org; Sun, 05 Sep 2010 10:09:23 +0000 Received: from pigeon.gentoo.org (localhost [127.0.0.1]) by pigeon.gentoo.org (Postfix) with SMTP id 73756E0592; Sun, 5 Sep 2010 10:08:52 +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 380A0E0592 for ; Sun, 5 Sep 2010 10:08:52 +0000 (UTC) Received: by wwf26 with SMTP id 26so4121382wwf.10 for ; Sun, 05 Sep 2010 03:08:51 -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=Irp29rYFVBk6WfWKKuJBzRuk98Ip2w+wtqGvR3XxDks=; b=AWQCc9GDiAOnlnOqRbgAhuDTQyvm1tJ7P/Hp8NX3Nr6WltUwAjwRzbncN+8tX+6XpH 5MhhqSkTqqewkT6wCTx0fyZN8k5u77kUyFSHTTKdKelGUQhcQ2fkdzWQ2L5gfUo1KFP2 1N2vmmZB2Yaw7PB4NfAmxWhmfAZmxSvsvHP5w= 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=GvpvfY8KSZsdDeiIAaN1tL/QuIXcA+oGbIXee5EgjXjkZjSIMtKMd61iQeyr+qy7Bn 3JV8dXArrVAxowWFN6IjVDHw1JJ3dOzQHwx1GR4O4Dh7WacI8vzhLQxmYRmnFn/70Nry DbtbZYHXq8LZLbU6jrcSQ/jZe5N3JR/CIJEWg= Received: by 10.216.71.85 with SMTP id q63mr2592281wed.53.1283681330012; Sun, 05 Sep 2010 03:08:50 -0700 (PDT) Received: from (230.3.169.217.in-addr.arpa [217.169.3.230]) by mx.google.com with ESMTPS id u32sm2521369weq.35.2010.09.05.03.08.48 (version=TLSv1/SSLv3 cipher=RC4-MD5); Sun, 05 Sep 2010 03:08:49 -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: Sun, 5 Sep 2010 11:08:46 +0100 User-Agent: KMail/1.13.5 (Linux/2.6.34-gentoo-r6; KDE/4.4.5; x86_64; ; ) References: <4C7D3C94.2070602@gmail.com> <201009042331.25204.michaelkintzios@gmail.com> <201009051030.01225.michaelkintzios@gmail.com> In-Reply-To: <201009051030.01225.michaelkintzios@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="nextPart2300007.NWi0HoWrB8"; protocol="application/pgp-signature"; micalg=pgp-sha1 Content-Transfer-Encoding: 7bit Message-Id: <201009051108.48450.michaelkintzios@gmail.com> X-Archives-Salt: 6d9c971d-c2cb-463b-99e4-3716edca2d8f X-Archives-Hash: f0fa98fb84f7c1d7e0cba1d202778021 --nextPart2300007.NWi0HoWrB8 Content-Type: Text/Plain; charset="iso-8859-15" Content-Transfer-Encoding: quoted-printable On Sunday 05 September 2010 10:29:29 you wrote: > On Saturday 04 September 2010 23:30:55 you wrote: > > 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 > > > >> them 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 ebuil= d. > > > 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. > >=20 > > I just updated to mysql-5.1.50-r1 on a x86 box, ran revdep-rebuild whi= ch > > amidst others rebuilt apache and php and all is good now. dispatch-conf > > updated only a couple of lines on the config file. > >=20 > > The default paths were not affected on any of the 5 mysql databases I'm > > running currently. >=20 > Oops! I spake too soon! :-( >=20 > I cannot access two databases. Both have #mysql50# infront of the name of > the original database. What does this mean? How do I fix it? Other > databases are fine, their names appearing without this strange prefix. I found the solution: mysql > ALTER DATABASE `#mysql50#dbname` UPGRADE DATA DIRECTORY NAME; as described here:=20 http://mattiasgeniar.be/2010/08/07/mysql-upgrade-to-5-1-database-name-prefi= x- mysql50/ I am not sure if this is related with the problem that the O/P had -=20 disappearing databases. The symptoms when the database with the new prefix= is=20 used to drive a CMS, was an error by apache saying that the database does n= ot=20 exist. Of course, it does exist but its name now has a funny prefix. Running mysql -u root -p and SHOW DATABASES; led me to finding out that the= =20 name had changed. BTW, /var/lib/mysql still showed the non-prefixed db nam= es. Anyway, the above link was very helpful in resolving my problem. =2D-=20 Regards, Mick --nextPart2300007.NWi0HoWrB8 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) iEYEABECAAYFAkyDbDAACgkQVTDTR3kpaLY6qwCeJDbEZBXL3RCnQ4DtQC7m3qIO yO4AnRHsWHIczmbpRDd9sE69PFsOPXm5 =ENik -----END PGP SIGNATURE----- --nextPart2300007.NWi0HoWrB8--