1 |
Nice work! Thank you! |
2 |
|
3 |
On Thu, 2005-09-08 at 00:38 +0200, Francesco R wrote: |
4 |
> If someone don't cut my fingers tomorrow MySQL 4.1 will be unmasked, |
5 |
> staying in ~ARCH for some time and become stable. |
6 |
> Waiting for a better doc from someone else, please review this upgrade |
7 |
> path since it's my intention to send it to gentoo-user@l.g.o |
8 |
> too . |
9 |
> |
10 |
> .----------------------- |
11 |
> | propedeutic readings: |
12 |
> |
13 |
> http://dev.mysql.com/doc/mysql/en/upgrading-from-4-0.html |
14 |
> http://dev.mysql.com/doc/mysql/en/news-4-1-x.html |
15 |
> http://dev.mysql.com/doc/mysql/en/replication-upgrade-4-0.html |
16 |
> |
17 |
> .--------------- |
18 |
> | Upgrade path: |
19 |
> |
20 |
> [[[ User with a old (<4.0.24 ??) mysql start from here ]]] |
21 |
> |
22 |
> quickpkg dev-db/mysql |
23 |
> |
24 |
> cmd# emerge -av --buildpkg =mysql-4.0.25-r2 |
25 |
> cmd# ebuild \ |
26 |
> /var/db/pkg/dev-db/mysql-4.0.25-r2/mysql-4.0.25-r2.ebuild config |
27 |
> |
28 |
> # Insert some kind of data fex attached "backup_mysql_4.0.sql.gz" |
29 |
> |
30 |
> [[[ User with a recent version of mysql start from here ]]] |
31 |
> |
32 |
> cmd# mysqldump \ |
33 |
> -uroot \ |
34 |
> -p$PASSWORD \ |
35 |
> -hlocalhost \ |
36 |
> --all-databases \ |
37 |
> --all \ |
38 |
> --opt \ |
39 |
> --allow-keywords \ |
40 |
> --flush-logs \ |
41 |
> --hex-blob \ |
42 |
> --master-data \ |
43 |
> --max_allowed_packet=16M \ |
44 |
> --result-file=BACKUP_MYSQL_4.0.SQL |
45 |
> |
46 |
> # check the backup file, try one one load on a mysql-4.0 server |
47 |
> |
48 |
> cmd# /etc/init.d/mysql stop |
49 |
> cmd# quickpkg dev-db/mysql |
50 |
> cmd# rm -rf /var/lib/mysql/ |
51 |
> |
52 |
> [[[ Real upgrade start here ]]] |
53 |
> |
54 |
> cmd# emerge -C mysql |
55 |
> cmd# rm -rf /var/lib/mysql/ /var/run/mysqld/ /var/log/mysql |
56 |
> cmd# emerge -av --buildpkg =mysql-4.1.14 |
57 |
> cmd# revdep-rebuild |
58 |
> cmd# ebuild /var/db/pkg/dev-db/mysql-4.1.14/mysql-4.1.14.ebuild config |
59 |
> cmd# /etc/init.d/mysql start |
60 |
> |
61 |
> cmd# cat backup_mysql_4.0.sql \ |
62 |
> | mysql \ |
63 |
> -uroot \ |
64 |
> -p$PASSWORD \ |
65 |
> -hlocalhost \ |
66 |
> --max_allowed_packet=16M |
67 |
> |
68 |
> cmd# mysql_fix_privilege_tables \ |
69 |
> --defaults-file=/etc/mysql/my.cnf \ |
70 |
> --user=root \ |
71 |
> --password=$PASSWORD |
72 |
> |
73 |
> cmd# /etc/init.d/mysql restart |
74 |
> ------------------------------------------------------------ |
75 |
|
76 |
|
77 |
-- |
78 |
gentoo-server@g.o mailing list |