Solved

Cannot start server instance MySQL

Posted on 2008-10-26
7
2,476 Views
Last Modified: 2010-10-05
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
Comment
Question by:rookie_b
  • 3
  • 2
  • 2
7 Comments
 
LVL 26

Expert Comment

by:ushastry
Comment Utility
Can you please post the error log contents... this should be in data dir

C:\mysql\data\*.err
0
 
LVL 8

Assisted Solution

by:rpkhare
rpkhare earned 250 total points
Comment Utility
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
 

Author Comment

by:rookie_b
Comment Utility
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
Do You Know the 4 Main Threat Actor Types?

Do you know the main threat actor types? Most attackers fall into one of four categories, each with their own favored tactics, techniques, and procedures.

 
LVL 8

Expert Comment

by:rpkhare
Comment Utility
Which OS you are using? Are you installing with administrative rights?
0
 
LVL 26

Expert Comment

by:ushastry
Comment Utility
Pls post your my.ini contents here
0
 
LVL 26

Assisted Solution

by:ushastry
ushastry earned 250 total points
Comment Utility
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
 

Accepted Solution

by:
rookie_b earned 0 total points
Comment Utility
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

What Is Threat Intelligence?

Threat intelligence is often discussed, but rarely understood. Starting with a precise definition, along with clear business goals, is essential.

Join & Write a Comment

Foreword In the years since this article was written, numerous hacking attacks have targeted password-protected web sites.  The storage of client passwords has become a subject of much discussion, some of it useful and some of it misguided.  Of cou…
Does the idea of dealing with bits scare or confuse you? Does it seem like a waste of time in an age where we all have terabytes of storage? If so, you're missing out on one of the core tools in every professional programmer's toolbox. Learn how to …
In this tutorial you'll learn about bandwidth monitoring with flows and packet sniffing with our network monitoring solution PRTG Network Monitor (https://www.paessler.com/prtg). If you're interested in additional methods for monitoring bandwidt…
When you create an app prototype with Adobe XD, you can insert system screens -- sharing or Control Center, for example -- with just a few clicks. This video shows you how. You can take the full course on Experts Exchange at http://bit.ly/XDcourse.

743 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

11 Experts available now in Live!

Get 1:1 Help Now