Re: Problem with data.MYD

["Michael Roberts" <mroberts () hrmc org>]

Wonderful, that worked like a charm!!

For future reference, what did that command do?  (myisamchk -r)

Thanks again for your time and help!

> > > "Roman Danyliw" <roman () danyliw com> 03/11/03 03:56PM >>>
Try the following (note that the extension .MYD is not used in the
command):

$ myisamchk -r data
$ mysqladmin flush-tables

If that does not work try:

$myisamchk -re data

Roman

On Tue, 11 Mar 2003 09:29:58 -0500, "Michael Roberts"
<mroberts () hrmc org> wrote :

> When I try running the following command, I receive the same error,
> doesn't have a correct index definition, you need to recreate it
before
> you can do a repair.
>
> $ myisamchk --keys-used=0 -rq data.MYD
>
> What should be my next step?
>
> Thanks so much for your help!
>
> > > > "Roman Danyliw" <roman () danyliw com> 03/11/03 08:59AM >>>
> Try the following:
>
> # -r (recover) -q (do not look at the data file)
>
> $ myisamchk --keys-used=0 -rq data.MYD
> $ mysqladmin flush-tables
>
> If this works you probably want to run the following commands the
> analyze and
> sort by the index:
>
> $ myisamchk -arS data.MYD
> $ mysqladmin flush-tables
>
>
> Cheers,
> Roman
>
>
> On Mon, 10 Mar 2003 14:28:01 -0500, "Michael Roberts"
> <mroberts () hrmc org> wrote :
>
> > I started experiencing problems with Snort running on Windows 2000
> with
> > MySQL giving the following error message:
> >
> > Database ERROR: Can't open file: data.MYD (error:145)
> >
> > This happens when I try to delete an alert from Snort or view the
> > payload of a packet.
> >
> > I have tried running myisamchk with the rebuild option and get the
> > following message:
> >
> > myisamchk: error: data.myd doesn't have a correct index definition.

> > You need to recreate it before you can do a repiar.
> >
> > I have searched, but have been unable to locate how to re-create
the
> > index.  My data.myd file is only 6 Mb, and I would not care if I
> lost
> > the data that was in it, I just need to get Snort fully functional
> > again.
> >
> > Please advise.
> >
> > Michael Roberts, MCNE, MCSA, CCA
> > Director of Network Services
> > Consolidated Health Systems
> > Highlands Regional Medical Center
> > mroberts () hrmc org 
> >
> >
> > -------------------------------------------------------
> > This sf.net email is sponsored by:ThinkGeek
> > Welcome to geek heaven.
> > http://thinkgeek.com/sf 
> > _______________________________________________
> > Snort-users mailing list
> > Snort-users () lists sourceforge net 
> > Go to this URL to change user options or unsubscribe:
> > https://lists.sourceforge.net/lists/listinfo/snort-users 
> > Snort-users list archive:
> > http://www.geocrawler.com/redir-sf.php3?list=snort-users 


-------------------------------------------------------
This SF.net email is sponsored by:Crypto Challenge is now open! 
Get cracking and register here for some mind boggling fun and 
the chance of winning an Apple iPod:
http://ads.sourceforge.net/cgi-bin/redirect.pl?thaw0031en
_______________________________________________
Snort-users mailing list
Snort-users () lists sourceforge net
Go to this URL to change user options or unsubscribe:
https://lists.sourceforge.net/lists/listinfo/snort-users
Snort-users list archive:
http://www.geocrawler.com/redir-sf.php3?list=snort-users