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@l.g.o
> 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@g.o mailing list