Solved

Cannot start server instance MySQL

Posted on 2008-10-26
7
2,527 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 3
  • 2
  • 2
7 Comments
 
LVL 26

Expert Comment

by:ushastry
ID: 22809705
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
ID: 22810315
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
ID: 22810590
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
Efficient way to get backups off site to Azure

This user guide provides instructions on how to deploy and configure both a StoneFly Scale Out NAS Enterprise Cloud Drive virtual machine and Veeam Cloud Connect in the Microsoft Azure Cloud.

 
LVL 8

Expert Comment

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

Expert Comment

by:ushastry
ID: 22810624
Pls post your my.ini contents here
0
 
LVL 26

Assisted Solution

by:ushastry
ushastry earned 250 total points
ID: 22822576
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
ID: 22826284
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

Efficient way to get backups off site to Azure

This user guide provides instructions on how to deploy and configure both a StoneFly Scale Out NAS Enterprise Cloud Drive virtual machine and Veeam Cloud Connect in the Microsoft Azure Cloud.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
join tables 4 57
insert into database through form with dynamic fields. 2 50
How to fix Datetime in MySQL? 4 66
Survey branching tutorial 11 42
Introduction In this installment of my SQL tidbits, I will be looking at parsing Extensible Markup Language (XML) directly passed as string parameters to MySQL 5.1.5 or higher. These would be instances where LOAD_FILE (http://dev.mysql.com/doc/refm…
Popularity Can Be Measured Sometimes we deal with questions of popularity, and we need a way to collect opinions from our clients.  This article shows a simple teaching example of how we might elect a favorite color by letting our clients vote for …
Email security requires an ever evolving service that stays up to date with counter-evolving threats. The Email Laundry perform Research and Development to ensure their email security service evolves faster than cyber criminals. We apply our Threat…

749 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