[gentoo-user] MySQL 4.0 => 4.1 upgrade

[gentoo-user] MySQL 4.0 => 4.1 upgrade

[Francesco R]

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

Re: [gentoo-user] MySQL 4.0 => 4.1 upgrade

[Bastian Balthazar Bux]

Free interpretation of Maurice van der Pot replay to this same email on
gentoo-dev :

>      --result-file=BACKUP_MYSQL_4.0.SQL
> 
[...]
> 
> cmd# cat backup_mysql_4.0.sql \

Those two are the same file, so either use lower or UPPER case name.

Also the password insterted during the
ebuild /var/db/pkg/dev-db/mysql-4.1.14/mysql-4.1.14.ebuild config
phase must avoid "'" charachters and is not checked at all.

Just to be sure avoid [_%'] charachters (more to add?)
-- 
gentoo-user@gentoo.org mailing list