Gentoo Archives: gentoo-user

From: Mick <michaelkintzios@×××××.com>
To: gentoo-user@l.g.o
Subject: Re: [gentoo-user] Proper way of updating mysql from 5.0.90-r2 to 5.1.50?
Date: Tue, 31 Aug 2010 18:31:47
Message-Id: 201008311931.08748.michaelkintzios@gmail.com
In Reply to: [gentoo-user] Proper way of updating mysql from 5.0.90-r2 to 5.1.50? by Jarry
1 On Tuesday 31 August 2010 18:32:04 Jarry wrote:
2 > Hi,
3 > what is the proper way of updating mysql? I did it as with
4 > any other package, following this sequence:
5 >
6 > emerge --ask --update --deep --newuse world
7 > [ebuild N ] net-misc/curl-7.20.0-r2 USE="idn ipv6 ssl -ares -gnutls
8 > -kerberos -ldap -libssh2 -nss -test"
9 > [ebuild N ] dev-util/cmake-2.8.1-r2 USE="ncurses -emacs -qt4
10 > -vim-syntax"
11 > [ebuild U ] dev-db/mysql-5.1.50 [5.0.90-r2] USE="-pbxt% -xtradb%"
12 > [ebuild U ] virtual/mysql-5.1 [5.0]
13 > emerge --depclean
14 > revdep-rebuild
15 > /etc/init.d/mysqld stop
16 > /etc/init.d/mysqld start
17 >
18 > But this is apparently not the proper way, because after
19 > restarting the server, apache does not show my web-page
20 > reporting there is no such a database. I checked it with
21 > phpmyadmin, and really, there is absolutely no database
22 > in mysql!
23 >
24 > I quickly restored backup version which I have done just
25 > before trying mysql-update, so my web-site is up and running.
26 > Now I would like to update mysql the right way, I but do not
27 > know how to do it...
28
29 Hi Jarry,
30
31 Some years ago I ran into some similar problem, I can't recall exactly what.
32 Lost in folklore (wiki?) were some instructions to first stop mysql before you
33 update it and I have been following them since.
34
35 I stop apach & mysql, run the update, dispatch-conf and then restart them
36 both. Haven't had problems since.
37
38 There may be a better way for doing this - in which case others who know
39 better will hopefully chime in.
40 --
41 Regards,
42 Mick

Attachments

File name MIME type
signature.asc application/pgp-signature

Replies