• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 2603
  • Last Modified:

Cannot start server instance MySQL

Hi,

I am havibg trouble installing MySQL Windows essentials 5  on WinXP SP2. When I get to the end of the instance configurarion wizzard it gives me "The service could not be started. Error:0". If I try to start the service manually from the services.msc it gives me "Could not start the MySQL service on local computer. Error 1067. The [rocess terminated unexpectedly".

I tried uninstalling MySQL, deleting folders, registry entries, deleting the service using "sc delete", but always get the same error.

I tried installing the gui tools and if I try to start Mysql through there I get the following in the log:

" Trying to start the server ...
Server could not be started.

Default storage engine (InnoDB) is not available

Aborting

C:\mysql\bin\mysqld-nt: Shutdown complete "

 

0
rookie_b
Asked:
rookie_b
  • 3
  • 2
  • 2
3 Solutions
 
UmeshMySQL Principle Technical Support EngineerCommented:
Can you please post the error log contents... this should be in data dir

C:\mysql\data\*.err
0
 
rpkhareCommented:
Uninstalling MySQL does not delete the old Data folder. Try this:

(1) Uninstall MySQL.
(2) Search for the MySQL\Data folder and delete it.
(3) Re-install.

I think it will work.
0
 
rookie_bAuthor Commented:
I did delete the folder manually when uninstaling, but did not help. Here is what the err log reads:

081026 23:27:17  InnoDB: Error: unable to create temporary file; errno: 22
081026 23:27:17 [ERROR] Default storage engine (InnoDB) is not available
081026 23:27:17 [ERROR] Aborting

081026 23:27:17 [Note] C:\mysql\bin\mysqld-nt: Shutdown complete

081026 23:31:25  InnoDB: Error: unable to create temporary file; errno: 9
081026 23:31:25 [ERROR] Default storage engine (InnoDB) is not available
081026 23:31:25 [ERROR] Aborting

081026 23:31:25 [Note] C:\mysql\bin\mysqld-nt: Shutdown complete

081026 23:34:17  InnoDB: Error: unable to create temporary file; errno: 9
081026 23:34:17 [ERROR] Default storage engine (InnoDB) is not available
081026 23:34:17 [ERROR] Aborting

081026 23:34:17 [Note] C:\mysql\bin\mysqld-nt: Shutdown complete

081026 23:34:38  InnoDB: Error: unable to create temporary file; errno: 9
081026 23:34:38 [ERROR] Default storage engine (InnoDB) is not available
081026 23:34:38 [ERROR] Aborting

081026 23:34:38 [Note] C:\mysql\bin\mysqld-nt: Shutdown complete

081026 23:36:08  InnoDB: Error: unable to create temporary file; errno: 9
081026 23:36:08 [ERROR] Default storage engine (InnoDB) is not available
081026 23:36:08 [ERROR] Aborting

081026 23:36:08 [Note] C:\mysql\bin\mysqld-nt: Shutdown complete

081026 23:36:48  InnoDB: Error: unable to create temporary file; errno: 9
081026 23:36:48 [ERROR] Default storage engine (InnoDB) is not available
081026 23:36:48 [ERROR] Aborting

081026 23:36:48 [Note] C:\mysql\bin\mysqld-nt: Shutdown complete

081026 23:40:47  InnoDB: Error: unable to create temporary file; errno: 9
081026 23:40:47 [ERROR] Default storage engine (InnoDB) is not available
081026 23:40:47 [ERROR] Aborting

081026 23:40:47 [Note] C:\mysql\bin\mysqld-nt: Shutdown complete

081026 23:41:14  InnoDB: Error: unable to create temporary file; errno: 9
081026 23:41:14 [ERROR] Default storage engine (InnoDB) is not available
081026 23:41:14 [ERROR] Aborting

081026 23:41:14 [Note] C:\mysql\bin\mysqld-nt: Shutdown complete

081026 23:42:11  InnoDB: Error: unable to create temporary file; errno: 9
081026 23:42:11 [ERROR] Default storage engine (InnoDB) is not available
081026 23:42:11 [ERROR] Aborting

081026 23:42:11 [Note] C:\mysql\bin\mysqld-nt: Shutdown complete

081026 23:45:42  InnoDB: Error: unable to create temporary file; errno: 9
081026 23:45:42 [ERROR] Default storage engine (InnoDB) is not available
081026 23:45:42 [ERROR] Aborting

081026 23:45:42 [Note] C:\mysql\bin\mysqld-nt: Shutdown complete

081026 23:46:12  InnoDB: Error: unable to create temporary file; errno: 9
081026 23:46:12 [ERROR] Default storage engine (InnoDB) is not available
081026 23:46:12 [ERROR] Aborting

081026 23:46:12 [Note] C:\mysql\bin\mysqld-nt: Shutdown complete

081026 23:46:22  InnoDB: Error: unable to create temporary file; errno: 9
081026 23:46:22 [ERROR] Default storage engine (InnoDB) is not available
081026 23:46:22 [ERROR] Aborting

081026 23:46:22 [Note] C:\mysql\bin\mysqld-nt: Shutdown complete

081026 23:47:12  InnoDB: Error: unable to create temporary file; errno: 9
081026 23:47:12 [ERROR] Default storage engine (InnoDB) is not available
081026 23:47:12 [ERROR] Aborting

081026 23:47:12 [Note] C:\mysql\bin\mysqld-nt: Shutdown complete

081026 23:48:10  InnoDB: Error: unable to create temporary file; errno: 9
081026 23:48:10 [ERROR] Default storage engine (InnoDB) is not available
081026 23:48:10 [ERROR] Aborting

081026 23:48:10 [Note] C:\mysql\bin\mysqld-nt: Shutdown complete

081026 23:52:42  InnoDB: Error: unable to create temporary file; errno: 9
081026 23:52:42 [ERROR] Default storage engine (InnoDB) is not available
081026 23:52:42 [ERROR] Aborting

081026 23:52:42 [Note] C:\mysql\bin\mysqld-nt: Shutdown complete

0
Free Tool: SSL Checker

Scans your site and returns information about your SSL implementation and certificate. Helpful for debugging and validating your SSL configuration.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

 
rpkhareCommented:
Which OS you are using? Are you installing with administrative rights?
0
 
UmeshMySQL Principle Technical Support EngineerCommented:
Pls post your my.ini contents here
0
 
UmeshMySQL Principle Technical Support EngineerCommented:
From the error log it seems

OS error code   9:  Bad file descriptor

Seems the innodb data file/log file has issues... can you please post innodb specific settings from my.ini.

Also if you don't want to use InnoDB engine then just change default engine type from Innodb to myisam
0
 
rookie_bAuthor Commented:
OK, here is the deal - I was installing "windows essentias", which does not have the inno db, when I should have been using the normal version. Thanks for all your comments!
0

Featured Post

Upgrade your Question Security!

Your question, your audience. Choose who sees your identity—and your question—with question security.

  • 3
  • 2
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now