Hi Ronaldo,
After some digging I did find a way!
USE mysql;
CREATE TABLE gn2 LIKE general_log;
RENAME TABLE general_log TO oldLogs, gn2 TO general_log;
the rename is atomic, so it is quick, there is no
need to stop the server. After that, oldLogs is
very easy to mess up with
thanks,
Jacek
Since that table is a MyISAM table, you must do the following:
01. In mysql, CREATE DATABASE IF NOT EXISTS mystuff;
02. service mysql stop
03. cd /var/lib/mysql/mysql
04. mv general_log.* ../mystuff
05. comment out general log from my.cnf
06. service mysql start
07. In mysql, DELETE FROM mystuff.g
