If a table is found to have a possible incompatibility,
41
If
42
42
\fBmysql_upgrade\fR
43
performs a table check\&. If any problems are found, a table repair is attempted\&. If the table cannot be repaired, see
44
Section\ \&2.4.4, \(lqRebuilding or Repairing Tables or Indexes\(rq
43
finds that a table has a possible incompatibility, it performs a table check and, if problems are found, attempts a table repair\&. If the table cannot be repaired, see
44
Section\ \&2.13.4, \(lqRebuilding or Repairing Tables or Indexes\(rq
45
45
for manual table repair strategies\&.
46
46
.if n \{\
47
47
.sp
52
52
.nr an-break-flag 1
53
53
.br
54
54
.ps +1
55
\fBNote\fR
56
.ps -1
57
.br
58
.PP
59
On Windows Server 2008, Vista, and newer, you must run
60
\fBmysql_upgrade\fR
61
with administrator privileges\&. You can do this by running a Command Prompt as Administrator and running the command\&. Failure to do so may result in the upgrade failing to execute correctly\&.
62
.sp .5v
63
.RE
64
.if n \{\
65
.sp
66
.\}
67
.RS 4
68
.it 1 an-trap
69
.nr an-no-space-flag 1
70
.nr an-break-flag 1
71
.br
72
.ps +1
55
73
\fBCaution\fR
56
74
.ps -1
57
75
.br
59
77
You should always back up your current MySQL installation
Some upgrade incompatibilities may require special handling before you upgrade your MySQL installation and run
65
83
\fBmysql_upgrade\fR\&. See
66
Section\ \&2.4.1, \(lqUpgrading MySQL\(rq, for instructions on determining whether any such incompatibilities apply to your installation and how to handle them\&.
84
Section\ \&2.13.1, \(lqUpgrading MySQL\(rq, for instructions on determining whether any such incompatibilities apply to your installation and how to handle them\&.
that contains SQL statements to upgrade the tables in the
150
168
mysql
189
207
\fBmysql_upgrade\fR
190
208
is included in the server RPM but requires the client RPM because the latter includes
191
209
\fBmysqlcheck\fR\&. (See
192
Section\ \&2.6.1, \(lqInstalling MySQL from RPM Packages on Linux\(rq\&.)
210
Section\ \&2.5.1, \(lqInstalling MySQL from RPM Packages on Linux\(rq\&.)
193
211
.PP
194
212
In MySQL 5\&.1\&.7,
195
213
\fBmysql_upgrade \fR
198
216
is an executable binary and is available on all systems\&.
199
217
.PP
200
218
\fBmysql_upgrade\fR
201
supports the options in the following list\&. It also reads option files (the
219
does not upgrade the contents of the help tables\&. For upgrade instructions, see
220
Section\ \&5.1.8, \(lqServer-Side Help\(rq\&.
221
.PP
222
\fBmysql_upgrade\fR
223
supports the following options, which can be specified on the command line or in the
202
224
[mysql_upgrade]
203
225
and
204
226
[client]
205
groups) and supports the options for processing them described at
206
Section\ \&4.2.3.3.1, \(lqCommand-Line Options that Affect Option-File Handling\(rq\&. Other options are passed to
227
groups of an option file\&. Other options are passed to
207
228
\fBmysqlcheck\fR\&. For example, it might be necessary to specify the
208
229
\fB\-\-password[=\fR\fB\fIpassword\fR\fR\fB]\fR
209
230
option\&.
231
\fBmysql_upgrade\fR
232
also supports the options for processing option files described at
233
Section\ \&4.2.3.3.1, \(lqCommand-Line Options that Affect Option-File Handling\(rq\&.
210
234
.sp
211
235
.RS 4
212
236
.ie n \{\
375
399
.SH "COPYRIGHT"
376
400
.br
377
401
.PP
378
Copyright 2007-2008 MySQL AB, 2009 Sun Microsystems, Inc.
402
Copyright \(co 1997, 2011, Oracle and/or its affiliates. All rights reserved.
379
403
.PP
380
404
This documentation is free software; you can redistribute it and/or modify it only under the terms of the GNU General Public License as published by the Free Software Foundation; version 2 of the License.
381
405
.PP
388
412
which may already be installed locally and which is also available