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 can run myisamchk while mysqld is running.
You might want to just use the "CHECK TABLE tablename" command, though,
which will always work.
--
Dan Nelson
[EMAIL PROTECTED]
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
