neysx 06/10/28 11:43:39 Modified: mysql-upgrading.xml Log: #108502 Mention restore problem with PK values <= 0
Revision Changes Path 1.16 xml/htdocs/doc/en/mysql-upgrading.xml file : http://sources.gentoo.org/viewcvs.py/gentoo/xml/htdocs/doc/en/mysql-upgrading.xml?rev=1.16&view=markup plain: http://sources.gentoo.org/viewcvs.py/gentoo/xml/htdocs/doc/en/mysql-upgrading.xml?rev=1.16&content-type=text/plain diff : http://sources.gentoo.org/viewcvs.py/gentoo/xml/htdocs/doc/en/mysql-upgrading.xml?r1=1.15&r2=1.16 Index: mysql-upgrading.xml =================================================================== RCS file: /var/cvsroot/gentoo/xml/htdocs/doc/en/mysql-upgrading.xml,v retrieving revision 1.15 retrieving revision 1.16 diff -u -r1.15 -r1.16 --- mysql-upgrading.xml 10 Sep 2006 21:27:57 -0000 1.15 +++ mysql-upgrading.xml 28 Oct 2006 11:43:39 -0000 1.16 @@ -1,6 +1,6 @@ <?xml version='1.0' encoding="UTF-8"?> <!DOCTYPE guide SYSTEM "/dtd/guide.dtd"> -<!-- $Header: /var/cvsroot/gentoo/xml/htdocs/doc/en/mysql-upgrading.xml,v 1.15 2006/09/10 21:27:57 nightmorph Exp $ --> +<!-- $Header: /var/cvsroot/gentoo/xml/htdocs/doc/en/mysql-upgrading.xml,v 1.16 2006/10/28 11:43:39 neysx Exp $ --> <guide link="/doc/en/mysql-upgrading.xml"> <title>Upgrade guide to MySQL 4.* or 5.0.*</title> @@ -22,8 +22,8 @@ <!-- See http://creativecommons.org/licenses/by-sa/2.5 --> <license/> -<version>1.12</version> -<date>2006-09-10</date> +<version>1.13</version> +<date>2006-10-28</date> <chapter> <title>Straight upgrade, suggested for 4.1 => 5.0 migration</title> @@ -43,7 +43,7 @@ <i>| sed -e 's|datadir[ \t]||')</i> # <i>MYSQL --execute="FLUSH TABLES WITH READ LOCK;"</i> # <i>tar -cjpvf ~/mysql.$(date +%F"T"%H-%M).tar.bz2 \</i> - <i>/etc/mysql/conf.d/mysql /etc/mysql/my.cnf "${DATADIR}"</i> + <i>/etc/conf.d/mysql /etc/mysql/my.cnf "${DATADIR}"</i> # <i>MYSQL --execute="UNLOCK TABLES;"</i> # <i>tar -tjvf ~/mysql.*.tar.bz2</i> # <i>emerge -av ">mysql-5.0"</i> @@ -85,6 +85,13 @@ <section> <body> +<impo> +Values inside primary keys are handled differently in various MySQL versions, +see <uri link="http://bugs.gentoo.org/108502";>bug #108502</uri> for more +details, it is higly recommended to scan your tables for values of "0" (zero) +or less and update them to a value greater than or equal to "1". +</impo> + <p> One of the most important tasks that every database administrator has to perform is backing up data. Here we go: -- [email protected] mailing list
