RE: Schema on Mysql

["Ibarra, Michael" <m.ibarra () cdcixis-na com>]

What? No, you do not need to drop the entire database just to change a
table. 
Look into the archives, this has already been discussed. DO NOT drop you
database, unless you do not care to keep any of its data. 

-----Original Message-----
From: R [mailto:rr () conformix com]
Sent: Tuesday, October 22, 2002 9:55 PM
To: Snort-Users@Lists. Sourceforge. Net
Subject: RE: [Snort-users] Schema on Mysql


The easiest way is to drop the old DB, create a new one and then create
tables using create_mysql:

Use these steps:

1. mysql localhost

2. drop database <database_name>

3. create database <database_name>

4. exit

5. mysql <database_name> <create_mysql

 

 

-----Original Message-----

From: snort-users-admin () lists sourceforge net [
<mailto:snort-users-admin () lists sourceforge net>
mailto:snort-users-admin () lists sourceforge net] On Behalf Of Brian Nestor

Sent: Monday, October 21, 2002 9:26 AM

To: snort-users () lists sourceforge net

Subject: [Snort-users] Schema on Mysql

 

I am trying to run snort and log the data to MYSQL for use with ACID. I am
getting an error. The underlying DB seems to be running and older version of
the DB Schema. I am running snort 1.87 and mysql 3.23.52. I used the
create_mysql script to create the tables in the DB. Any help would be
appreciated. Thanks

Brian