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: Sun, 05 Sep 2010 09:30:58
Message-Id: 201009051030.01225.michaelkintzios@gmail.com
In Reply to: Re: [gentoo-user] Proper way of updating mysql from 5.0.90-r2 to 5.1.50? by Mick
1 On Saturday 04 September 2010 23:30:55 you wrote:
2 > On Saturday 04 September 2010 22:43:01 kashani wrote:
3 > > On 9/3/2010 10:53 PM, Jarry wrote:
4 > > > On 31. 8. 2010 20:30, Mick wrote:
5 > > >> I stop apach& mysql, run the update, dispatch-conf and then restart
6 > > >> them both. Haven't had problems since.
7 > > >
8 > > > I tried it that way:
9 > > >
10 > > > /etc/init.d/apache2 stop
11 > > > /etc/init.d/mysql stop
12 > > > emerge --ask --update --deep --newuse world
13 > > > emerge --depclean
14 > > > revdep-rebuild
15 > > > /etc/init.d/mysql start
16 > > > /etc/init.d/apache2 start
17 > > >
18 > > > Still the same: databases are gone, mysql is empty. Only users
19 > > > are there. This is strange: how can updating mysql from one stable
20 > > > version to higher stable cause complete loss of databases???
21 > > >
22 > > > Jarry
23 > >
24 > > IIRC the default my.cnf changed for the worse in Gentoo's 5.1.x ebuild.
25 > > Try making a copy of your original my.cnf and put it into place once
26 > > you've upgraded. Else you may need to modify the mysql home and data
27 > > paths in the new my.cnf to reflect where the database are actually
28 > > installed.
29 >
30 > I just updated to mysql-5.1.50-r1 on a x86 box, ran revdep-rebuild which
31 > amidst others rebuilt apache and php and all is good now. dispatch-conf
32 > updated only a couple of lines on the config file.
33 >
34 > The default paths were not affected on any of the 5 mysql databases I'm
35 > running currently.
36
37 Oops! I spake too soon! :-(
38
39 I cannot access two databases. Both have #mysql50# infront of the name of the
40 original database. What does this mean? How do I fix it? Other databases
41 are fine, their names appearing without this strange prefix.
42 --
43 Regards,
44 Mick

Attachments

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

Replies

Subject Author
Re: [gentoo-user] Proper way of updating mysql from 5.0.90-r2 to 5.1.50? Mick <michaelkintzios@×××××.com>