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)

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, you