Hello, Is there a way to purge parts of general log table without interrupting the server? Ideally, we would like to transfer older logs (say copy all entries from 2010 into a separate location, and then run:
DELETE FROM mysql.general_log WHERE event_time<'2011-01-01' However this yields an error: ERROR 1556 (HY000): You can't use locks with log tables. What is a recommended way to clean up mysql.general_log? Thanks, Jacek -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/mysql?unsub=arch...@jab.org
