MySQL Bugs: #43845: MySQL 5.1 installation fails at 'Start Service'

Bug #43845	MySQL 5.1 installation fails at 'Start Service'
Submitted:	25 Mar 0:01	Modified:	25 Mar 7:45
Reporter:	Kalyan Yalamanchili
Status:	Duplicate
Category:	Server: Installing	Severity:	S2 (Serious)
Version:	5.1.32	OS:	Microsoft Windows (Vista Business 32-bit)
Assigned to:		Target Version:

Description:
I am trying to install MySQL on Vista Business 32-bit and it fails at start service. I
have searched the forums and found out using this command and obtained the this below
log.

C:\Program Files\MySQL\MySQL Server 5.1\bin>mysqld -nt --defaults-file="C:\Progr
am Files\MySQL\MySQL Server 5.1\my.ini" --standalone --console
090324 15:44:47  InnoDB: Error: unable to create temporary file; errno: 2
090324 15:44:47 [ERROR] Plugin 'InnoDB' init function returned error.
090324 15:44:47 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.

090324 15:44:47 [ERROR] Unknown/unsupported table type: INNODB
090324 15:44:47 [ERROR] Aborting

090324 15:44:47 [Warning] Forcing shutdown of 1 plugins
090324 15:44:47 [Note] mysqld: Shutdown complete

Right from start it didn't pass through this problem. I had tried various times like
uninstalling (clean up registry and all its directories) and re-installing. No success.

How to repeat:

MySQL Server Instance Configuration Wizard 1.0.15.0 go through all the process till
hitting execute

Thank you for the bug report. Please see in your my.ini file the path for the datadir
directory, i.e:

datadir="C:/ProgramData/MySQL/MySQL Server 5.1/Data/"

Then open a command prompt and go to that folder and doing a dir command see if the below
InnoDB files have the same size of my.ini file:

c:\>cd "C:/ProgramData/MySQL/MySQL Server 5.1/Data/"

C:\ProgramData\MySQL\MySQL Server 5.1\data>dir ib*
 O volume na unidade C não tem nome.
 O Número de Série do Volume é F4C1-E357

 Pasta de C:\ProgramData\MySQL\MySQL Server 5.1\data

24/03/2009  16:57        10.485.760 ibdata1
24/03/2009  16:59        25.165.824 ib_logfile0
24/03/2009  09:18        25.165.824 ib_logfile1
               3 arquivo(s)     60.817.408 bytes
               0 pasta(s)   55.030.525.952 bytes disponíveis

C:\ProgramData\MySQL\MySQL Server 5.1\data>

If ibdata1 = 10M then it is the default one.
ib_logfile0 and ib_logfile1 according my.ini i.e:

innodb_log_file_size=24M

If you did a fresh install (you don't have data to preserve) then delete the above files
and try to start the service again. If the service fails please print here the message
error printed in the computer_name.err file which exists in the datadir folder. Thanks in
advance.

I do have the files u have mentioned 

C:\ProgramData\MySQL\MySQL Server 5.1\data>

If ibdata1 = 10M then it is the default one.
ib_logfile0 and ib_logfile1 according my.ini i.e:

innodb_log_file_size=24M

I have deleted those files as the installation is a fresh one and have tried the 'MySQL
Server Installation Configuration' wizard and went through all the process until clicking
execute... 

This time it says : "The service could not be started."

Log is as follows:

C:\Program Files\MySQL\MySQL Server 5.1\bin>mysqld -nt -defaults-file="C:\Progrm
 Files\MySQL\MySQL Server 5.1\my.ini" --standalone --console
090324 18:27:28  InnoDB: Error: unable to create temporary file; errno: 2
090324 18:27:28 [ERROR] Plugin 'InnoDB' init function returned error.
090324 18:27:28 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.

090324 18:27:28 [ERROR] Unknown/unsupported table type: INNODB
090324 18:27:28 [ERROR] Aborting

090324 18:27:28 [Warning] Forcing shutdown of 1 plugins
090324 18:27:28 [Note] mysqld: Shutdown complete

Thanks for your concern into this issue.

Thank you for the feedback.

Server can not start, because temporary directory is not writable. 

This is duplicate of bug #40757. More details and workaround in bug #40768.

Please wait next release.