De Luispa

Actualización de 5.0 a 5.1

Preparación

• Keywords

=dev-db/mysql-5.1.44                                  ~amd64
=virtual/mysql-5.1                                    ~amd64

• Use (Quito embedded en amarok)

media-sound/amarok            daap -embedded ipod mtp opengl

• Leo las guías recomendadas por "news"

# eselect news read 9
 2010-02-21-mysql-upgrade
  Title                     MySQL 5.1 unmasking and upgrade procedures
  Author                    Robin H. Johnson <robbat2@gentoo.org>
  Posted                    2010-02-21
  Revision                  3
 :
 :
 The official upgrade documentation is available here:
 http://dev.mysql.com/doc/refman/5.1/en/upgrade.html

Y otras guías encontradas por ahí
http://www.pkdavies.co.uk/blog/gentoo-mysql-5-1-upgrade

Backup

• Backup de las bases de datos:

$ mysqldump -uroot --password="<contraseña>" -hlocalhost --all-databases --opt --allow-keywords --flush-logs --hex-blob --master-data --max_allowed_packet=16M --quote-names --result-file=/dir/de/backups/2010-02-21-BACKUP_MYSQL_5.0.SQL

• Otro backup por si acaso, lo salvo "todo" :-)

# /etc/init.d/mysql stop
# tar cjpvf mysql.$(date +%F"T"%H-%M).tar.bz2 /etc/mysql/my.cnf /data/mysql/

Instalación

• Paro MySql y todos los programas que hagan uso de la base de datos

# /etc/init.d/<programas> stop
# /etc/init.d/mysql stop

• Realizo el Upgrade

# emerge -DuvNp mysql
These are the packages that would be merged, in order:
Calculating dependencies... done!
[ebuild     U ] dev-db/mysql-5.1.44 [5.0.84-r1] USE="community embedded perl ssl -big-tables -cluster -debug -extraengine -latin1 -max-idx-128 -minimal -profiling (-selinux) -static -test% (-berkdb%)" 23,767 kB
[ebuild     U ] virtual/mysql-5.1 [5.0] 0 kB

• Arranco MySql

# /etc/init.d/mysql start

• Ejecuto mysql_upgrade

# mysql_upgrade -h localhost -u root -p 

• revdep-rebuild y reinstalaciones que he realizado

# revdep-rebuild --library libmysqlclient.so.15
# revdep-rebuild
# emerge apache php

---

--Luis 20:43 21 feb 2010 (CET)