From mboxrd@z Thu Jan 1 00:00:00 1970 Received: from lists.gentoo.org ([140.105.134.102] helo=robin.gentoo.org) by nuthatch.gentoo.org with esmtp (Exim 4.60) (envelope-from ) id 1Gdn4E-0006Nk-HV for garchives@archives.gentoo.org; Sat, 28 Oct 2006 12:13:38 +0000 Received: from robin.gentoo.org (localhost [127.0.0.1]) by robin.gentoo.org (8.13.8/8.13.6) with SMTP id k9SCDBQX012498; Sat, 28 Oct 2006 12:13:11 GMT Received: from smtp.gentoo.org (smtp.gentoo.org [140.211.166.183]) by robin.gentoo.org (8.13.8/8.13.6) with ESMTP id k9SCD3ju024783 for ; Sat, 28 Oct 2006 12:13:06 GMT Received: from lark (lark.gentoo.osuosl.org [140.211.166.177]) (using TLSv1 with cipher DHE-RSA-AES256-SHA (256/256 bits)) (No client certificate requested) by smtp.gentoo.org (Postfix) with SMTP id E517A64B5E for ; Sat, 28 Oct 2006 11:43:39 +0000 (UTC) Received: by lark (sSMTP sendmail emulation); Sat, 28 Oct 2006 11:43:39 +0000 From: "Xavier Neys" Date: Sat, 28 Oct 2006 11:43:39 +0000 To: gentoo-doc-cvs@lists.gentoo.org Subject: [gentoo-doc-cvs] cvs commit: mysql-upgrading.xml Message-Id: <20061028114339.E517A64B5E@smtp.gentoo.org> Precedence: bulk List-Post: List-Help: List-Unsubscribe: List-Subscribe: List-Id: Gentoo Linux mail X-BeenThere: gentoo-doc-cvs@gentoo.org Reply-to: docs-team@lists.gentoo.org X-Archives-Salt: 85f55d39-4ed6-4f15-a763-a7f79b760c59 X-Archives-Hash: e5bfdb4d1848c388f8ce3c1dd94a824d 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 @@ - + Upgrade guide to MySQL 4.* or 5.0.* @@ -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 various MySQL versions, +see bug #108502 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". + +

One of the most important tasks that every database administrator has to perform is backing up data. Here we go: -- gentoo-doc-cvs@gentoo.org mailing list