| 1 |
neysx 06/10/28 11:43:39 |
| 2 |
|
| 3 |
Modified: mysql-upgrading.xml |
| 4 |
Log: |
| 5 |
#108502 Mention restore problem with PK values <= 0 |
| 6 |
|
| 7 |
Revision Changes Path |
| 8 |
1.16 xml/htdocs/doc/en/mysql-upgrading.xml |
| 9 |
|
| 10 |
file : http://sources.gentoo.org/viewcvs.py/gentoo/xml/htdocs/doc/en/mysql-upgrading.xml?rev=1.16&view=markup |
| 11 |
plain: http://sources.gentoo.org/viewcvs.py/gentoo/xml/htdocs/doc/en/mysql-upgrading.xml?rev=1.16&content-type=text/plain |
| 12 |
diff : http://sources.gentoo.org/viewcvs.py/gentoo/xml/htdocs/doc/en/mysql-upgrading.xml?r1=1.15&r2=1.16 |
| 13 |
|
| 14 |
Index: mysql-upgrading.xml |
| 15 |
=================================================================== |
| 16 |
RCS file: /var/cvsroot/gentoo/xml/htdocs/doc/en/mysql-upgrading.xml,v |
| 17 |
retrieving revision 1.15 |
| 18 |
retrieving revision 1.16 |
| 19 |
diff -u -r1.15 -r1.16 |
| 20 |
--- mysql-upgrading.xml 10 Sep 2006 21:27:57 -0000 1.15 |
| 21 |
+++ mysql-upgrading.xml 28 Oct 2006 11:43:39 -0000 1.16 |
| 22 |
@@ -1,6 +1,6 @@ |
| 23 |
<?xml version='1.0' encoding="UTF-8"?> |
| 24 |
<!DOCTYPE guide SYSTEM "/dtd/guide.dtd"> |
| 25 |
-<!-- $Header: /var/cvsroot/gentoo/xml/htdocs/doc/en/mysql-upgrading.xml,v 1.15 2006/09/10 21:27:57 nightmorph Exp $ --> |
| 26 |
+<!-- $Header: /var/cvsroot/gentoo/xml/htdocs/doc/en/mysql-upgrading.xml,v 1.16 2006/10/28 11:43:39 neysx Exp $ --> |
| 27 |
|
| 28 |
<guide link="/doc/en/mysql-upgrading.xml"> |
| 29 |
<title>Upgrade guide to MySQL 4.* or 5.0.*</title> |
| 30 |
@@ -22,8 +22,8 @@ |
| 31 |
<!-- See http://creativecommons.org/licenses/by-sa/2.5 --> |
| 32 |
<license/> |
| 33 |
|
| 34 |
-<version>1.12</version> |
| 35 |
-<date>2006-09-10</date> |
| 36 |
+<version>1.13</version> |
| 37 |
+<date>2006-10-28</date> |
| 38 |
|
| 39 |
<chapter> |
| 40 |
<title>Straight upgrade, suggested for 4.1 => 5.0 migration</title> |
| 41 |
@@ -43,7 +43,7 @@ |
| 42 |
<i>| sed -e 's|datadir[ \t]||')</i> |
| 43 |
# <i>MYSQL --execute="FLUSH TABLES WITH READ LOCK;"</i> |
| 44 |
# <i>tar -cjpvf ~/mysql.$(date +%F"T"%H-%M).tar.bz2 \</i> |
| 45 |
- <i>/etc/mysql/conf.d/mysql /etc/mysql/my.cnf "${DATADIR}"</i> |
| 46 |
+ <i>/etc/conf.d/mysql /etc/mysql/my.cnf "${DATADIR}"</i> |
| 47 |
# <i>MYSQL --execute="UNLOCK TABLES;"</i> |
| 48 |
# <i>tar -tjvf ~/mysql.*.tar.bz2</i> |
| 49 |
# <i>emerge -av ">mysql-5.0"</i> |
| 50 |
@@ -85,6 +85,13 @@ |
| 51 |
<section> |
| 52 |
<body> |
| 53 |
|
| 54 |
+<impo> |
| 55 |
+Values inside primary keys are handled differently in various MySQL versions, |
| 56 |
+see <uri link="http://bugs.gentoo.org/108502">bug #108502</uri> for more |
| 57 |
+details, it is higly recommended to scan your tables for values of "0" (zero) |
| 58 |
+or less and update them to a value greater than or equal to "1". |
| 59 |
+</impo> |
| 60 |
+ |
| 61 |
<p> |
| 62 |
One of the most important tasks that every database administrator has to |
| 63 |
perform is backing up data. Here we go: |
| 64 |
|
| 65 |
|
| 66 |
|
| 67 |
-- |
| 68 |
gentoo-doc-cvs@g.o mailing list |
Archives