Re: Could not start the MySQL service: Error 1067

[Donny Widjaja]

The message in .err file that was posted by evident-interactif does not start from the beginning. I will get the same error message when I try to start the MySQL service again.

This is the first part of the error message, when I installed MySQL using the Window Wizard with all default configuration.

------ beginning of error message ------
InnoDB: The first specified data file .\ibdata1 did not exist:
InnoDB: a new database to be created!
060131 1:16:15 InnoDB: Setting file .\ibdata1 size to 10 MB
InnoDB: Database physically writes the file full: wait...
InnoDB: Error: all log files must be created at the same time.
InnoDB: All log files must be created also in database creation.
InnoDB: If you want bigger or smaller log files, shut down the
InnoDB: database and make sure there were no errors in shutdown.
InnoDB: Then delete the existing log files. Edit the .cnf file
InnoDB: and start the database again.
060131 1:16:16 [ERROR] Default storage engine (InnoDB) is not available
060131 1:16:16 [ERROR] Aborting

060131 1:16:16 [Note] C:\Program Files\MySQL\MySQL Server 5.0\bin\mysqld-nt: Shutdown complete
------ end of error message ------

After I got this error message, I remove the MySQL server instance and re-install it, but this time, instead of using the default configuration, I choose the "Detailed Configuration", and I selected "Non-Transactional Database only" which disable the InnoDB storage engine. Now... it successfully started the MySQL services on my Windows XP.

I'm not sure why the default storage engine (InnoDB) is not available. Can someone tell me which file is the storage engine? Any ideas on how to run default storage engine manually, if possible ?

-- Donny