使用isamchk。exe 出现下面内容,我不知道说明怎么用。。 请问我要修复zgmove数据库怎么使用这个命令???samchk.exe Ver 5.17 for Win95/Win98 at i32 TCX Datakonsult AB, by Monty, for your professional use This software comes with NO WARRANTY: see the PUBLIC for details.Description, check and repair of ISAM tables. Used without options all tables on the command will be checked for errors Usage: isamchk.exe [OPTIONS] tables[.ISM] -a, --analyze Analyze distribution of keys. Will make some joins in MySQL faster. -#, --debug=... Output debug log. Often this is 'd:t:o,filename` --character-sets-dir=... Directory where character sets are -C, --default-character-set=... Set the default character set -d, --description Prints some information about table. -e, --extend-check Check the table VERY thoroughly. One need use this only in extreme cases as isamchk should normally find all errors even without this switch -f, --force Overwrite old temporary files. If one uses -f when checking tables (running isamchk without -r), isamchk will automatically restart with -r on any wrong table. -?, --help Display this help and exit. -i, --information Print statistics information about the table -k, --keys-used=# Used with '-r'. Tell ISAM to update only the first # keys. This can be used to get faster inserts! -l, --no-symlinks Do not follow symbolic links when repairing. Normally isamchk repairs the table a symlink points at. -q, --quick Used with -r to get a faster repair. (The data file isn't touched.) One can give a second '-q' to force isamchk to modify the original datafile. -r, --recover Can fix almost anything except unique keys that aren't unique. -o, --safe-recover Uses old recovery method; slower than '-r' but can handle a couple of cases that '-r' cannot handle. -O, --set-variable var=option Change the value of a variable. -s, --silent Only print errors. One can use two -s to make isamchk very silent -S, --sort-index Sort index blocks. This speeds up 'read-next' in applications -R, --sort-records=# Sort records according to an index. This makes your data much more localized and may speed up things (It may be VERY slow to do a sort the first time!) -u, --unpack Unpack file packed with pack_isam. -v, --verbose Print more information. This can be used with -d and -e. Use many -v for more verbosity! -V, --version Print version and exit. -w, --wait Wait if table is locked.Default options are read from the following files in the given order: C:\WINDOWS\my.ini C:\my.cnf The following groups are read: isamchk The following options may be given as the first argument: --print-defaults Print the program argument list and exit --no-defaults Don't read default options from any options file --defaults-file=# Only read default options from the given file # --defaults-extra-file=# Read this file after the global files are readPossible variables for option --set-variable (-O) are: key_buffer_size current value: 520192 read_buffer_size current value: 262136 write_buffer_size current value: 262136 sort_buffer_size current value: 2097144 sort_key_blocks current value: 16 decode_bits current value: 9
请问我要修复zgmove数据库怎么使用这个命令???samchk.exe Ver 5.17 for Win95/Win98 at i32
TCX Datakonsult AB, by Monty, for your professional use
This software comes with NO WARRANTY: see the PUBLIC for details.Description, check and repair of ISAM tables.
Used without options all tables on the command will be checked for errors
Usage: isamchk.exe [OPTIONS] tables[.ISM] -a, --analyze Analyze distribution of keys. Will make some joins in
MySQL faster.
-#, --debug=... Output debug log. Often this is 'd:t:o,filename`
--character-sets-dir=...
Directory where character sets are
-C, --default-character-set=...
Set the default character set
-d, --description Prints some information about table.
-e, --extend-check Check the table VERY thoroughly. One need use this
only in extreme cases as isamchk should normally find
all errors even without this switch
-f, --force Overwrite old temporary files.
If one uses -f when checking tables (running isamchk
without -r), isamchk will automatically restart with
-r on any wrong table.
-?, --help Display this help and exit.
-i, --information Print statistics information about the table
-k, --keys-used=# Used with '-r'. Tell ISAM to update only the first
# keys. This can be used to get faster inserts!
-l, --no-symlinks Do not follow symbolic links when repairing. Normally
isamchk repairs the table a symlink points at.
-q, --quick Used with -r to get a faster repair. (The data file
isn't touched.) One can give a second '-q' to force
isamchk to modify the original datafile.
-r, --recover Can fix almost anything except unique keys that aren't
unique.
-o, --safe-recover Uses old recovery method; slower than '-r' but can
handle a couple of cases that '-r' cannot handle.
-O, --set-variable var=option
Change the value of a variable.
-s, --silent Only print errors. One can use two -s to make isamchk
very silent
-S, --sort-index Sort index blocks. This speeds up 'read-next' in
applications
-R, --sort-records=#
Sort records according to an index. This makes your
data much more localized and may speed up things
(It may be VERY slow to do a sort the first time!)
-u, --unpack Unpack file packed with pack_isam.
-v, --verbose Print more information. This can be used with
-d and -e. Use many -v for more verbosity!
-V, --version Print version and exit.
-w, --wait Wait if table is locked.Default options are read from the following files in the given order:
C:\WINDOWS\my.ini C:\my.cnf
The following groups are read: isamchk
The following options may be given as the first argument:
--print-defaults Print the program argument list and exit
--no-defaults Don't read default options from any options file
--defaults-file=# Only read default options from the given file #
--defaults-extra-file=# Read this file after the global files are readPossible variables for option --set-variable (-O) are:
key_buffer_size current value: 520192
read_buffer_size current value: 262136
write_buffer_size current value: 262136
sort_buffer_size current value: 2097144
sort_key_blocks current value: 16
decode_bits current value: 9
Usage: isamchk.exe [OPTIONS] tables[.ISM]
选项:
-c 检查
-r 修复另外根据你的表的类型有可能是isamchk.exe或者myisamchk.exeSQL语句:
REPAIR TABLE tbl_name[,tbl_name...]
该方式只适用于MyISAM类型的表,相当于命令行方式下的:myisamchk -r table_name