Backup Software - Re: Backup Exec - not backing up - MySql: Can't open file: 'wt

Author

Re: Backup Exec - not backing up - MySql: Can't open file: 'wt_hostmetrichistory.MYI'.

Jurrien

2007-03-05, 1:14 pm

On 2 mrt, 16:50, gar...@gmail.com wrote:
> It seems all my backup jobs fail. In the event viewer - >-->
> application -> I have errors with "MySql: Can't open file:
> 'wt_hostmetrichistory.MYI'. (errno: 145)". I'm assuming this means a
> corrupted msql table? Any way to resolve this?

Yes, you should run myisamchk.exe on this corrupted mysql database
file after stopping the mysql database. Normally on Windows, it is
running as a service.

D:\Program Files\WebTrends\common\database\mysql\da
ta\wt_sched>..\..
\bin\myisamchk.exe -e -r wt_hostmetrichistory.MYI

This command will fix the database file and will prevent mysql from
filling up your eventviewer. Just happen to have the same problem this
morning on a server running Webtrends.