Bug #17991 General log doesn't have --init-file statements
Submitted: 6 Mar 2006 20:47 Modified: 6 Mar 2006 22:53
Reporter: Peter Gulutzan Email Updates:
Status: Verified Impact on me:
Category:MySQL Server: Logging Severity:S4 (Feature request)
Version:5.1.8-beta-debug/5.0BK/4.1BK OS:Linux (SUSE 10.0)
Assigned to: CPU Architecture:Any

[6 Mar 2006 20:47] Peter Gulutzan
I start the server with both --log and --init-file.
The statements in the --init-file are done.
But they don't appear in the general log.

How to repeat:
Assume the existence of a database named db1.

Create /tmp/init.txt with these three lines:

use db1;
create table tff (s1 int);
delete from mysql.event;

Start mysqld with
--user=root --skip-networking --log=/tmp/tmp.txt --log-output=table --init-file=/tmp/init.txt

You can use mysql to verify that table tff was created.

Look at /tmp/tmp.txt. The statements from init-file are not there.
[6 Mar 2006 22:53] MySQL Verification Team
Thank you for the bug report. Also the same happens on servers 4.1/5.0.