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 |