|
Lines 27-33
Link Here
|
| 27 |
<!-- See http://creativecommons.org/licenses/by-sa/2.5 --> |
27 |
<!-- See http://creativecommons.org/licenses/by-sa/2.5 --> |
| 28 |
<license/> |
28 |
<license/> |
| 29 |
|
29 |
|
| 30 |
<version>1</version> |
30 |
<version>2</version> |
| 31 |
<date>2006-01-30</date> |
31 |
<date>2006-01-30</date> |
| 32 |
|
32 |
|
| 33 |
<chapter> |
33 |
<chapter> |
|
Lines 162-170
Link Here
|
| 162 |
"skip-grant-tables" |
162 |
"skip-grant-tables" |
| 163 |
) |
163 |
) |
| 164 |
EOF</i> |
164 |
EOF</i> |
| 165 |
# <i>/etc/init.d/mysql-500 start</i> |
165 |
# <i>/etc/init.d/mysql start</i> |
| 166 |
# <i>mysql-500 --defaults-file=/etc/mysql-500/my.cnf < BACKUP_MYSQL_4.0.SQL</i> |
166 |
# <i>mysql-500 --defaults-file=/etc/mysql-500/my.cnf < BACKUP_MYSQL_4.0.SQL</i> |
| 167 |
# <i>/etc/init.d/mysql-500 stop</i> |
167 |
# <i>/etc/init.d/mysql stop</i> |
| 168 |
# <i>mv /etc/conf.d/mysql.orig /etc/conf.d/mysql</i> |
168 |
# <i>mv /etc/conf.d/mysql.orig /etc/conf.d/mysql</i> |
| 169 |
</pre> |
169 |
</pre> |
| 170 |
|
170 |
|
|
Lines 203-219
Link Here
|
| 203 |
</p> |
203 |
</p> |
| 204 |
|
204 |
|
| 205 |
<p> |
205 |
<p> |
|
|
206 |
Before you switch to the new MySQL server, you will have to adjust the following |
| 207 |
variable inside the <path>/etc/conf.d/mysql</path>. Its value might be empty: |
| 208 |
</p> |
| 209 |
|
| 210 |
<pre caption="Adjusting the mysql_slot_500 variable"> |
| 211 |
# <i>nano -w /etc/conf.d/mysql</i> |
| 212 |
<comment>(Add the following line:)</comment> |
| 213 |
<i>mysql_slot_500=( )</i> |
| 214 |
</pre> |
| 215 |
|
| 216 |
<p> |
| 206 |
When you're satisfied with the results, remove every test setting, stop the old |
217 |
When you're satisfied with the results, remove every test setting, stop the old |
| 207 |
server and start the new one. Also, be sure to add |
218 |
server and start the new one: |
| 208 |
<path>/etc/init.d/mysql</path> to the default runlevel, ensuring it starts at |
|
|
| 209 |
the next reboot. |
| 210 |
</p> |
219 |
</p> |
| 211 |
|
220 |
|
| 212 |
<pre caption="Using the new server"> |
221 |
<pre caption="Using the new server"> |
| 213 |
# <i>rc-update del mysql default</i> |
222 |
# <i>killall mysqld</i> |
| 214 |
# <i>rc-update add mysql-500 default</i> |
223 |
# <i>/etc/init.d/mysql stop zap start</i> |
| 215 |
# <i>/etc/init.d/mysql stop</i> |
|
|
| 216 |
# <i>/etc/init.d/mysql-500 start</i> |
| 217 |
</pre> |
224 |
</pre> |
| 218 |
|
225 |
|
| 219 |
<p> |
226 |
<p> |
