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

This is Interesting: Free IT Magazines  
Home > Archive > Backup Software > March 2007 > Re: Backup Exec - not backing up - MySql: Can't open file: 'wt_hostmetrichistory.MYI'.





You are viewing an archived Text-only version of the thread. To view this thread in it's original format and/or if you want to reply to this thread please [click here]

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.

Sponsored Links






Free braindumps | Software forum | Database administration forum

Copyright 2003 - 2008 webservertalk.com