Gentoo Archives: gentoo-user

From: Francesco R <vivo@g.o>
To: gentoo-user@l.g.o
Subject: [gentoo-user] MySQL 4.0 => 4.1 upgrade
Date: Thu, 08 Sep 2005 11:12:44
Message-Id: 43201636.7020007@gentoo.org
1 Please notice that MySQL-5.0 has been erroneously unmasked for few hours
2 but it will return under the package.mask cover at next rsync.
3
4 The MySQL herd is pleased to announce that Mysql 4.1 has been unmasked
5 today and is now marked unstable.
6 Hope that it's possible to stabilize it soon, here there is a upgrade path.
7
8 .-----------------------
9 | propedeutic readings:
10
11 http://dev.mysql.com/doc/mysql/en/upgrading-from-4-0.html
12 http://dev.mysql.com/doc/mysql/en/news-4-1-x.html
13 http://dev.mysql.com/doc/mysql/en/replication-upgrade-4-0.html
14
15 .---------------
16 | Upgrade path:
17
18 [[[ User with a old (<4.0.24 ??) mysql start from here ]]]
19
20 quickpkg dev-db/mysql
21
22 cmd# emerge -av --buildpkg =mysql-4.0.25-r2
23 cmd# ebuild \
24 /var/db/pkg/dev-db/mysql-4.0.25-r2/mysql-4.0.25-r2.ebuild config
25
26 # Insert some kind of data fex attached "backup_mysql_4.0.sql.gz"
27
28 [[[ User with a recent version of mysql start from here ]]]
29
30 cmd# mysqldump \
31 -uroot \
32 -p$PASSWORD \
33 -hlocalhost \
34 --all-databases \
35 --all \
36 --opt \
37 --allow-keywords \
38 --flush-logs \
39 --hex-blob \
40 --master-data \
41 --max_allowed_packet=16M \
42 --result-file=BACKUP_MYSQL_4.0.SQL
43
44 # check the backup file, try one one load on a mysql-4.0 server
45
46 cmd# /etc/init.d/mysql stop
47 cmd# quickpkg dev-db/mysql
48 cmd# rm -rf /var/lib/mysql/
49
50 [[[ Real upgrade start here ]]]
51
52 cmd# emerge -C mysql
53 cmd# rm -rf /var/lib/mysql/ /var/run/mysqld/ /var/log/mysql
54 cmd# emerge -av --buildpkg =mysql-4.1.14
55 cmd# revdep-rebuild
56 cmd# ebuild /var/db/pkg/dev-db/mysql-4.1.14/mysql-4.1.14.ebuild config
57 cmd# /etc/init.d/mysql start
58
59 cmd# cat backup_mysql_4.0.sql \
60 | mysql \
61 -uroot \
62 -p$PASSWORD \
63 -hlocalhost \
64 --max_allowed_packet=16M
65
66 cmd# mysql_fix_privilege_tables \
67 --defaults-file=/etc/mysql/my.cnf \
68 --user=root \
69 --password=$PASSWORD
70
71 cmd# /etc/init.d/mysql restart
72 ------------------------------------------------------------
73
74 --
75 gentoo-user@g.o mailing list

Replies

Subject Author
Re: [gentoo-user] MySQL 4.0 => 4.1 upgrade Bastian Balthazar Bux <BastianBalthazarBux@×××××××××.it>