Please notice that MySQL-5.0 has been erroneously unmasked for few hours
but it will return under the package.mask cover at next rsync.

The MySQL herd is pleased to announce that Mysql 4.1 has been unmasked
today and is now marked unstable.
Hope that it's possible to stabilize it soon, here there is a upgrade path.

.-----------------------
| propedeutic readings:

http://dev.mysql.com/doc/mysql/en/upgrading-from-4-0.html
http://dev.mysql.com/doc/mysql/en/news-4-1-x.html
http://dev.mysql.com/doc/mysql/en/replication-upgrade-4-0.html

.---------------
| Upgrade path:

[[[ User with a old (<4.0.24 ??) mysql start from here ]]]

quickpkg dev-db/mysql

cmd# emerge -av --buildpkg =mysql-4.0.25-r2
cmd# ebuild \
     /var/db/pkg/dev-db/mysql-4.0.25-r2/mysql-4.0.25-r2.ebuild config

# Insert some kind of data fex attached "backup_mysql_4.0.sql.gz"

[[[ User with a recent version of mysql start from here ]]]

cmd# mysqldump \
     -uroot \
     -p$PASSWORD \
     -hlocalhost \
     --all-databases \
     --all \
     --opt \
     --allow-keywords \
     --flush-logs \
     --hex-blob \
     --master-data \
     --max_allowed_packet=16M \
     --result-file=BACKUP_MYSQL_4.0.SQL

# check the backup file, try one one load on a mysql-4.0 server

cmd# /etc/init.d/mysql stop
cmd# quickpkg dev-db/mysql
cmd# rm -rf /var/lib/mysql/

[[[ Real upgrade start here ]]]

cmd# emerge -C mysql
cmd# rm -rf /var/lib/mysql/ /var/run/mysqld/ /var/log/mysql
cmd# emerge -av --buildpkg =mysql-4.1.14
cmd# revdep-rebuild
cmd# ebuild /var/db/pkg/dev-db/mysql-4.1.14/mysql-4.1.14.ebuild config
cmd# /etc/init.d/mysql start

cmd# cat backup_mysql_4.0.sql \
     | mysql \
     -uroot \
     -p$PASSWORD \
     -hlocalhost \
     --max_allowed_packet=16M

cmd# mysql_fix_privilege_tables \
     --defaults-file=/etc/mysql/my.cnf \
     --user=root \
     --password=$PASSWORD

cmd# /etc/init.d/mysql restart
------------------------------------------------------------

-- 
gentoo-user@gentoo.org mailing list

Reply via email to