Snort MySql

Posted on 2007-10-11
Last Modified: 2010-04-20
I have a Linux machine setup to run Snort to monitor my network. Its been several months and the number of alerts is huge. Is there a good way to clear out the database? Its using MySql, and I know next to nothing about MySql.
Question by:JeffBeall
    LVL 3

    Expert Comment

    You could do a backup of your database (if you want to save the information) and then wipe out the tables and start over. What do you use to access your MySQL database?
    LVL 19

    Accepted Solution

    See this url:

    basically, they are droping the database and then creating it again empty.

    is that what you want?
    LVL 1

    Author Comment

    Thanks for the link, near the bottom it had something about clearing the cache when you use Base. I tried it and it worked great.
    LVL 19

    Expert Comment


    other way to do it is enter to the database but you would need to understand which parameters should be used:

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    IT, Stop Being Called Into Every Meeting

    Highfive is so simple that setting up every meeting room takes just minutes and every employee will be able to start or join a call from any room with ease. Never be called into a meeting just to get it started again. This is how video conferencing should work!

    As a database administrator, you may need to audit your table(s) to determine whether the data types are optimal for your real-world data needs.  This Article is intended to be a resource for such a task. Preface The other day, I was involved …
    Password hashing is better than message digests or encryption, and you should be using it instead of message digests or encryption.  Find out why and how in this article, which supplements the original article on PHP Client Registration, Login, Logo…
    Learn several ways to interact with files and get file information from the bash shell. ls lists the contents of a directory: Using the -a flag displays hidden files: Using the -l flag formats the output in a long list: The file command gives us mor…
    Connecting to an Amazon Linux EC2 Instance from Windows Using PuTTY.

    737 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    16 Experts available now in Live!

    Get 1:1 Help Now