Revision [1716]
Last edited on 2008-05-14 00:05:52 by WikiAdminAdditions:
===myisamchk===
If you want to check all MyISAM tables and repair any that are corrupted, you can use the following command:
myisamchk --silent --force --fast --update-state \
--key_buffer_size=64M --sort_buffer_size=64M \
--read_buffer_size=1M --write_buffer_size=1M \
/path/to/datadir/*/*.MYI
If you want to check all MyISAM tables and repair any that are corrupted, you can use the following command:
myisamchk --silent --force --fast --update-state \
--key_buffer_size=64M --sort_buffer_size=64M \
--read_buffer_size=1M --write_buffer_size=1M \
/path/to/datadir/*/*.MYI
Revision [915]
Edited on 2007-08-30 20:32:32 by WikiAdminAdditions:
If the error code is 145, do a **myismchk /path/to/db.MYI** will fix the error.
