Snort mailing list archives

Re: Flushing the data from the MySQL database


From: "Josh Berry" <josh.berry () netschematics com>
Date: Tue, 14 Oct 2003 09:16:58 -0500 (CDT)

Access mysql: mysql -h <host> -D <database> -u <user> -p

For each Snort/ACID table type in:
TRUNCATE TABLE <tablename>;

I was running Snort on a trial basis, and I am now ready to have it run
in full operational mode. There is a considerable amount of data in the
datbase, and I would like to remove it, and start fresh. The database I
am using is MySQL 4.0.14. What is the easiest way to do this. I can
access the
database either via
the command line or through Webmin. Thanks.


-------------------------------------------------------
This SF.net email is sponsored by: SF.net Giveback Program.
SourceForge.net hosts over 70,000 Open Source Projects.
See the people who have HELPED US provide better services:
Click here: http://sourceforge.net/supporters.php
_______________________________________________
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



Thanks,
Josh Berry, CTO
LinkNet-Solutions
469-831-8543
josh.berry () linknet-solutions com




Thanks,
Josh Berry, CTO
LinkNet-Solutions
469-831-8543
josh.berry () linknet-solutions com



-------------------------------------------------------
This SF.net email is sponsored by: SF.net Giveback Program.
SourceForge.net hosts over 70,000 Open Source Projects.
See the people who have HELPED US provide better services:
Click here: http://sourceforge.net/supporters.php
_______________________________________________
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: