1MYISAMLOG(1) MySQL Database System MYISAMLOG(1)
2
3
4
6 myisamlog - display MyISAM log file contents
7
9 myisamlog [options] [log_file [tbl_name] ...]
10
12 myisamlog processes the contents of a MyISAM log file. To create such a
13 file, start the server with a --log-isam=log_file option.
14
15 Invoke myisamlog like this:
16
17 shell> myisamlog [options] [file_name [tbl_name] ...]
18
19 The default operation is update (-u). If a recovery is done (-r), all
20 writes and possibly updates and deletes are done and errors are only
21 counted. The default log file name is myisam.log if no log_file
22 argument is given. If tables are named on the command line, only those
23 tables are updated.
24
25 myisamlog supports the following options:
26
27 · -?, -I
28
29 Display a help message and exit.
30
31 · -c N
32
33 Execute only N commands.
34
35 · -f N
36
37 Specify the maximum number of open files.
38
39 · -F filepath/
40
41 Specify the file path with a trailing slash.
42
43 · -i
44
45 Display extra information before exiting.
46
47 · -o offset
48
49 Specify the starting offset.
50
51 · -p N
52
53 Remove N components from path.
54
55 · -r
56
57 Perform a recovery operation.
58
59 · -R record_pos_file record_pos
60
61 Specify record position file and record position.
62
63 · -u
64
65 Perform an update operation.
66
67 · -v
68
69 Verbose mode. Print more output about what the program does. This
70 option can be given multiple times to produce more and more output.
71
72 · -w write_file
73
74 Specify the write file.
75
76 · -V
77
78 Display version information.
79
81 Copyright © 1997, 2020, Oracle and/or its affiliates. All rights
82 reserved.
83
84 This documentation is free software; you can redistribute it and/or
85 modify it only under the terms of the GNU General Public License as
86 published by the Free Software Foundation; version 2 of the License.
87
88 This documentation is distributed in the hope that it will be useful,
89 but WITHOUT ANY WARRANTY; without even the implied warranty of
90 MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the GNU
91 General Public License for more details.
92
93 You should have received a copy of the GNU General Public License along
94 with the program; if not, write to the Free Software Foundation, Inc.,
95 51 Franklin Street, Fifth Floor, Boston, MA 02110-1301 USA or see
96 http://www.gnu.org/licenses/.
97
98
100 For more information, please refer to the MySQL Reference Manual, which
101 may already be installed locally and which is also available online at
102 http://dev.mysql.com/doc/.
103
105 Oracle Corporation (http://dev.mysql.com/).
106
107
108
109MySQL 8.0 03/06/2020 MYISAMLOG(1)