mysql.general_log custom colums
Hi, until mysql 5.5 i was able to add a custom column in mysql.general_log table, it's works fine
SET GLOBAL general_log = 'OFF';
RENAME TABLE general_log TO general_log_temp;
ALTER TABLE `general_log_temp`
ADD COLUMN `event_unix` int(10) NOT NULL AFTER `event_time`;
RENAME TABLE general_log_temp TO general_log;
SET GLOBAL general_log = 'ON';
In mysql 5.6 I can add the colums with success but no logs are stored
#mysql -V
Ver 14.14 Distrib 5.6.15, for debian6.0 (x86_64) using EditLine wrapper)
2015-11-02 14:22:52 7357 [ERROR] Failed to write to mysql.general_log:
2015-11-02 14:22:52 7357 [ERROR] Column count of mysql.general_log is wrong. Expected 6, found 7. The table is probably corrupted
Any help please^?
Subject
Written By
Posted
mysql.general_log custom colums
November 02, 2015 07:49AM
November 03, 2015 11:56AM
November 04, 2015 02:59AM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.