Bug #61360 init_file sytem variable prevents startup of mysql
Submitted: 31 May 2011 8:18 Modified: 2 Jul 2011 3:35
Reporter: Greg Rossel Email Updates:
Status: No Feedback Impact on me:
Category:MySQL Server: General Severity:S2 (Serious)
Version:5.1.41-3 OS:Linux (ubuntu12.10)
Assigned to: CPU Architecture:Any
Tags: init_file hangs mysql

[31 May 2011 8:18] Greg Rossel
when init_file is set in my.cnf mysql will not start up. Even if I put a blank init file it will not work.

In init.sql I have tried a variety of queries and a empty file.

I made sure to have single line queries with no ';'.

I have made sure that the init.sql permissions were wide open.

When I start up mysql it hangs. This is an important problem since memory tables cannot be automatically loaded on reboot. Perhaps someone could suggest a workaround. This may relate to some of the system variable problems I have seen from other users.


How to repeat:
in my.cnf add the following line in the [mysqld] section: 

init_file = /etc/mysql/init.sql

Make a file init.sql and add a query without ';' or simply leave the file empty.

Start mysql and it will not start.
[2 Jun 2011 3:35] Alexey Kishkin
Just tested agains current GA release mysql 5.1.57  and was not able to reproduce it.

Greg, could you please to check if this bug still persists in your environment if you use mysql 5.1.57.

Version 5.1.43 is little bit outdated (especially if count you are writting from the future -- "ubuntu 12.10").
[2 Jul 2011 23:00] Bugs System
No feedback was provided for this bug for over a month, so it is
being suspended automatically. If you are able to provide the
information that was originally requested, please do so and change
the status of the bug back to "Open".