Kernel_Killer
October 24th, 2003, 04:53
Everywhere I've found ample amounts of ways to backup the database even when the tables are getting to large, but never read anything about how to clear the logs.

Right now, I'm just trying to do a routine database flush since barnyard likes to hold tons of logs. For me pushing 50MB+ of logs over my network is a bit annoying, especially when they are old logs. I guess I could take my chances at a table flush, but since it seems that it will flush all the descriptions and everything, I figured I'd ask here first. TIA :D

soup4you2
October 24th, 2003, 09:10
Are we talking about mysql logs, tables, or something completely diffrent?

if it's just your barnyard logs.. just either delete them or gzip them up.

Kernel_Killer
October 24th, 2003, 18:17
Whatever logs are being spewed into sguil is what I want to remove, or backup (if mysqldump didn't get them).

soup4you2
October 24th, 2003, 19:08
mysql> \u squildb;
mysql> show tables;
mysql> truncate (the table you want to clean);

if your unsure whats in a table

select * from TABLE;

*side note** truncating a table will erase all contents inside it. often used for removing watermarks, etc,etc