Re: how to check .MYI file withour shutdown database

2002-10-07 Thread Dan Nelson
In the last episode (Oct 08), Patrick Hsieh said: > Hello list, > > Can I use myisamchk to check the index without shutdown the mysql > server? As long as your mysqld is running with locking enabled. You can check by running " SHOW VARIABLES LIKE 'skip_external_locking' ". If it's set to NO, y

how to check .MYI file withour shutdown database

2002-10-07 Thread Patrick Hsieh
Hello list, Can I use myisamchk to check the index without shutdown the mysql server? - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive)