Snort mailing list archives
RE: Schema on Mysql
From: "Ibarra, Michael" <m.ibarra () cdcixis-na com>
Date: Wed, 23 Oct 2002 09:11:16 -0400
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
Current thread:
- Schema on Mysql Brian Nestor (Oct 21)
- <Possible follow-ups>
- RE: Schema on Mysql R (Oct 22)
- RE: Schema on Mysql Ibarra, Michael (Oct 23)