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
• Status: Verified
• Category: MySQL Server: Logging
• Severity: S4 (Feature request)
• Version: 5.1.8-beta-debug/5.0BK/4.1BK
• OS: Linux (SUSE 10.0)
• CPU Architecture: Any

[6 Mar 2006 20:47] Peter Gulutzan

Description:
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.