myisamlog man page

myisamlog — display MyISAM log file contents


myisamlog [options] [log_file [tbl_name] ...]


myisamlog processes the contents of a MyISAM log file. To create such a file, start the server with a --log-isam=log_file option.

Invoke myisamlog like this:

shell> myisamlog [options] [file_name [tbl_name] ...]

The default operation is update (-u). If a recovery is done (-r), all writes and possibly updates and deletes are done and errors are only counted. The default log file name is myisam.log if no log_file argument is given. If tables are named on the command line, only those tables are updated.

myisamlog supports the following options:

· -?, -I

Display a help message and exit.
· -c N

Execute only N commands.
· -f N

Specify the maximum number of open files.
· -i

Display extra information before exiting.
· -o offset

Specify the starting offset.
· -p N

Remove N components from path.
· -r

Perform a recovery operation.
· -R record_pos_file record_pos

Specify record position file and record position.
· -u

Perform an update operation.
· -v

Verbose mode. Print more output about what the program does. This option can be given multiple times to produce more and more output.
· -w write_file

Specify the write file.
· -V

Display version information.

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


Oracle Corporation (

Referenced By


11/26/2016 MySQL 5.7 MySQL Database System