clearing out DB?

[scorth]

Hello guys,
I have got a Mysql running for DB back end for Snort and I wanna create a weekly back up which i have but i also wanna DB to be clear out and each week it start over fresh, so how to achieve this?
Thanks!! -- This message may have been cut off and the rest will only be shown to members. To become a member, click here --

[Beau]

With the database, run a mysqldump --no-data one time so you have the schema for your tables. Each time you need to clear the database, rename the old one, recreate the new one, and import the mysqldump file to recreate the tables.

But you aren't going to run into performance issues leaving your records in your database until you get into the millions of rows. If you tweak your servers correctly you won't see performance issues. -- This message may have been cut off and the rest will only be shown to members. To become a member, click here --