[gentoo-server] MySQL 4.0 => 4.1 upgrade

[gentoo-server] MySQL 4.0 => 4.1 upgrade

[Francesco R]

If someone don't cut my fingers tomorrow MySQL 4.1 will be unmasked,
staying in ~ARCH for some time and become stable.
Waiting for a better doc from someone else, please review this upgrade
path since it's my intention to send it to gentoo-user@lists.gentoo.org
too .

.-----------------------
| 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-server@gentoo.org mailing list

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

[xyon]

Nice work! Thank you!

On Thu, 2005-09-08 at 00:38 +0200, Francesco R wrote:
> If someone don't cut my fingers tomorrow MySQL 4.1 will be unmasked,
> staying in ~ARCH for some time and become stable.
> Waiting for a better doc from someone else, please review this upgrade
> path since it's my intention to send it to gentoo-user@lists.gentoo.org
> too .
> 
> .-----------------------
> | 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-server@gentoo.org mailing list