List:General Discussion« Previous MessageNext Message »
From:Dan Nelson Date:October 8 2002 5:32am
Subject:Re: how to check .MYI file withour shutdown database
View as plain text  
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
	dnelson@stripped
Thread
how to check .MYI file withour shutdown databasePatrick Hsieh8 Oct
  • Re: how to check .MYI file withour shutdown databaseDan Nelson8 Oct