~ubuntu-branches/ubuntu/wily/mysql-5.6/wily

'\" t

.\"     Title: \fBinnochecksum\fR

.\"    Author: [FIXME: author] [see http://docbook.sf.net/el/author]

.\" Generator: DocBook XSL Stylesheets v1.78.1 <http://docbook.sf.net/>

.\"      Date: 05/05/2015

.\"    Manual: MySQL Database System

.\"    Source: MySQL 5.6

.\"  Language: English

.\"

.TH "\FBINNOCHECKSUM\FR" "1" "05/05/2015" "MySQL 5\&.6" "MySQL Database System"

.\" -----------------------------------------------------------------

.\" * Define some portability stuff

.\" -----------------------------------------------------------------

.\" ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

.\" http://bugs.debian.org/507673

.\" http://lists.gnu.org/archive/html/groff/2009-02/msg00013.html

.\" ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

.ie \n(.g .ds Aq \(aq

.el       .ds Aq '

.\" -----------------------------------------------------------------

.\" * set default formatting

.\" -----------------------------------------------------------------

.\" disable hyphenation

.nh

.\" disable justification (adjust text to left margin only)

.ad l

.\" -----------------------------------------------------------------

.\" * MAIN CONTENT STARTS HERE *

.\" -----------------------------------------------------------------

.\" innochecksum

.SH "NAME"

innochecksum \- offline InnoDB file checksum utility

.SH "SYNOPSIS"

.HP \w'\fBinnochecksum\ [\fR\fB\fIoptions\fR\fR\fB]\ \fR\fB\fIfile_name\fR\fR\ 'u

\fBinnochecksum [\fR\fB\fIoptions\fR\fR\fB] \fR\fB\fIfile_name\fR\fR

.SH "DESCRIPTION"

.PP

\fBinnochecksum\fR

prints checksums for

InnoDB

files\&. This tool reads an

InnoDB

tablespace file, calculates the checksum for each page, compares the calculated checksum to the stored checksum, and reports mismatches, which indicate damaged pages\&. It was originally developed to speed up verifying the integrity of tablespace files after power outages but can also be used after file copies\&. Because checksum mismatches will cause

InnoDB

to deliberately shut down a running server, it can be preferable to use this tool rather than waiting for a server in production usage to encounter the damaged pages\&. As of MySQL 5\&.6\&.16,

\fBinnochecksum\fR

supports files greater than 2GB in size\&. Previously,

\fBinnochecksum\fR

only supported files up to 2GB in size\&.

.PP

\fBinnochecksum\fR

cannot be used on tablespace files that the server already has open\&. For such files, you should use

CHECK TABLE

to check tables within the tablespace\&.

.PP

If checksum mismatches are found, you would normally restore the tablespace from backup or start the server and attempt to use

\fBmysqldump\fR

to make a backup of the tables within the tablespace\&.

.PP

Invoke

\fBinnochecksum\fR

like this:

.sp

.if n \{\

.RS 4

.\}

.nf

shell> \fBinnochecksum [\fR\fB\fIoptions\fR\fR\fB] \fR\fB\fIfile_name\fR\fR

.fi

.if n \{\

.RE

.\}

.PP

\fBinnochecksum\fR

supports the following options\&. For options that refer to page numbers, the numbers are zero\-based\&.

.sp

.RS 4

.ie n \{\

\h'-04'\(bu\h'+03'\c

.\}

.el \{\

.sp -1

.IP \(bu 2.3

.\}

\fB\-c\fR

.sp

Print a count of the number of pages in the file\&.

.RE

.sp

.RS 4

.ie n \{\

\h'-04'\(bu\h'+03'\c

.\}

.el \{\

.sp -1

.IP \(bu 2.3

.\}

\fB\-d\fR

.sp

Debug mode; prints checksums for each page\&.

.RE

.sp

.RS 4

.ie n \{\

\h'-04'\(bu\h'+03'\c

.\}

.el \{\

.sp -1

.IP \(bu 2.3

.\}

\fB\-e \fR\fB\fInum\fR\fR

.sp

End at this page number\&.

.RE

.sp

.RS 4

.ie n \{\

\h'-04'\(bu\h'+03'\c

.\}

.el \{\

.sp -1

.IP \(bu 2.3

.\}

\fB\-p \fR\fB\fInum\fR\fR

.sp

Check only this page number\&.

.RE

.sp

.RS 4

.ie n \{\

\h'-04'\(bu\h'+03'\c

.\}

.el \{\

.sp -1

.IP \(bu 2.3

.\}

\fB\-s \fR\fB\fInum\fR\fR

.sp

Start at this page number\&.

.RE

.sp

.RS 4

.ie n \{\

\h'-04'\(bu\h'+03'\c

.\}

.el \{\

.sp -1

.IP \(bu 2.3

.\}

\fB\-v\fR

.sp

Verbose mode; print a progress indicator every five seconds\&.

.RE

.SH "COPYRIGHT"

.br

.PP

Copyright \(co 1997, 2015, Oracle and/or its affiliates. All rights reserved.

.PP

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.

.PP

This documentation is distributed in the hope that it will be useful, but WITHOUT ANY WARRANTY; without even the implied warranty of MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the GNU General Public License for more details.

.PP

You should have received a copy of the GNU General Public License along with the program; if not, write to the Free Software Foundation, Inc., 51 Franklin Street, Fifth Floor, Boston, MA 02110-1301 USA or see http://www.gnu.org/licenses/.

.sp

.SH "SEE ALSO"

For more information, please refer to the MySQL Reference Manual,

which may already be installed locally and which is also available

online at http://dev.mysql.com/doc/.

.SH AUTHOR

Oracle Corporation (http://dev.mysql.com/).