> -----Original Message----- > From: Chris [mailto:[EMAIL PROTECTED] > Sent: Thursday, July 27, 2006 22:42 > To: Dirk Bremer > Cc: mysql@lists.mysql.com > Subject: Re: Mysqlcheck issues > > Dirk Bremer wrote: > > I am using MySQL server 4.1.10 on Windows 2003 Server with MyISAM > > tables. I have an issue where occasionally an index (MYI) > file becomes > > corrupted. I do not know why this occurs. To combat this > issue, I tried > > running the following command every half-hour: > > > > mysqlcheck -Aamov --auto-repair --use-frm > > > > This command runs on the host. For some reason, when this command > > executes, the MySQL service aborts and the MYI for the main table is > > corrupted. I must then restart the service and repair the affected > > table. > > Do you get any errors in the logfiles? > > Not sure why that would be corrupting the database tables, > what user are > you running this as (root, mysql) ?
The mysql_error.log file does not reveal the problem. The mysqlcheck runs with administrative privileges under Windows and a privileged MySQl user. Dirk Bremer - Senior Systems Engineer - ESS/AMS - NISC Lake St. Louis MO - USA Central Time Zone 636-755-2652 fax 636-755-2503 [EMAIL PROTECTED] www.nisc.coop -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]