Index: mysql-upgrading.xml =================================================================== RCS file: /var/cvsroot/gentoo/xml/htdocs/doc/en/mysql-upgrading.xml,v retrieving revision 1.15 diff -u -B -r1.15 mysql-upgrading.xml --- mysql-upgrading.xml 10 Sep 2006 21:27:57 -0000 1.15 +++ mysql-upgrading.xml 28 Oct 2006 11:22:08 -0000 @@ -22,8 +22,8 @@ -1.12 -2006-09-10 +1.13 +2006-10-28 Straight upgrade, suggested for 4.1 => 5.0 migration @@ -43,7 +43,7 @@ | sed -e 's|datadir[ \t]||') # MYSQL --execute="FLUSH TABLES WITH READ LOCK;" # tar -cjpvf ~/mysql.$(date +%F"T"%H-%M).tar.bz2 \ - /etc/mysql/conf.d/mysql /etc/mysql/my.cnf "${DATADIR}" + /etc/conf.d/mysql /etc/mysql/my.cnf "${DATADIR}" # MYSQL --execute="UNLOCK TABLES;" # tar -tjvf ~/mysql.*.tar.bz2 # emerge -av ">mysql-5.0" @@ -85,6 +85,13 @@
+ +Values inside primary keys are handled differently in the various MySQL +versions, see link="https://bugs.gentoo.org/108502">bug #108502 +for some implications, it's higly recommended to scan your tables for values +of "0" (zero) or less and move them to a value greater or equal than "1". + +

One of the most important tasks that every database administrator has to perform is backing up data. Here we go: