|
Lines 22-29
Link Here
|
| 22 |
<!-- See http://creativecommons.org/licenses/by-sa/2.5 --> |
22 |
<!-- See http://creativecommons.org/licenses/by-sa/2.5 --> |
| 23 |
<license/> |
23 |
<license/> |
| 24 |
|
24 |
|
| 25 |
<version>1.12</version> |
25 |
<version>1.13</version> |
| 26 |
<date>2006-09-10</date> |
26 |
<date>2006-10-28</date> |
| 27 |
|
27 |
|
| 28 |
<chapter> |
28 |
<chapter> |
| 29 |
<title>Straight upgrade, suggested for 4.1 => 5.0 migration</title> |
29 |
<title>Straight upgrade, suggested for 4.1 => 5.0 migration</title> |
|
Lines 43-49
Link Here
|
| 43 |
<i>| sed -e 's|datadir[ \t]||')</i> |
43 |
<i>| sed -e 's|datadir[ \t]||')</i> |
| 44 |
# <i>MYSQL --execute="FLUSH TABLES WITH READ LOCK;"</i> |
44 |
# <i>MYSQL --execute="FLUSH TABLES WITH READ LOCK;"</i> |
| 45 |
# <i>tar -cjpvf ~/mysql.$(date +%F"T"%H-%M).tar.bz2 \</i> |
45 |
# <i>tar -cjpvf ~/mysql.$(date +%F"T"%H-%M).tar.bz2 \</i> |
| 46 |
<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> |
47 |
# <i>MYSQL --execute="UNLOCK TABLES;"</i> |
| 48 |
# <i>tar -tjvf ~/mysql.*.tar.bz2</i> |
48 |
# <i>tar -tjvf ~/mysql.*.tar.bz2</i> |
| 49 |
# <i>emerge -av ">mysql-5.0"</i> |
49 |
# <i>emerge -av ">mysql-5.0"</i> |
|
Lines 85-90
Link Here
|
| 85 |
<section> |
85 |
<section> |
| 86 |
<body> |
86 |
<body> |
| 87 |
|
87 |
|
|
|
88 |
<impo> |
| 89 |
Values inside primary keys are handled differently in the various MySQL |
| 90 |
versions, see <uri>link="https://bugs.gentoo.org/108502">bug #108502</uri> |
| 91 |
for some implications, it's higly recommended to scan your tables for values |
| 92 |
of "0" (zero) or less and move them to a value greater or equal than "1". |
| 93 |
</impo> |
| 94 |
|
| 88 |
<p> |
95 |
<p> |
| 89 |
One of the most important tasks that every database administrator has to |
96 |
One of the most important tasks that every database administrator has to |
| 90 |
perform is backing up data. Here we go: |
97 |
perform is backing up data. Here we go: |
