Snort mailing list archives
Re: Problem with data.MYD
From: "Roman Danyliw" <roman () danyliw com>
Date: Tue, 11 Mar 2003 08:59:50 -0500 (EST)
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
Current thread:
- Problem with data.MYD Michael Roberts (Mar 11)
- <Possible follow-ups>
- Re: Problem with data.MYD Roman Danyliw (Mar 11)
- Re: Problem with data.MYD Roman Danyliw (Mar 11)
- Re: Problem with data.MYD Michael Roberts (Mar 12)
- Re: Problem with data.MYD Michael Roberts (Mar 12)