?
Solved

Cannot start server instance MySQL

Posted on 2008-10-26
7
Medium Priority
?
2,550 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:Umesh
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 1000 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
Will your db performance match your db growth?

In Percona’s white paper “Performance at Scale: Keeping Your Database on Its Toes,” we take a high-level approach to what you need to think about when planning for database scalability.

 
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:Umesh
ID: 22810624
Pls post your my.ini contents here
0
 
LVL 26

Assisted Solution

by:Umesh
Umesh earned 1000 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

NFR key for Veeam Agent for Linux

Veeam is happy to provide a free NFR license for one year.  It allows for the non‑production use and valid for five workstations and two servers. Veeam Agent for Linux is a simple backup tool for your Linux installations, both on‑premises and in the public cloud.

Question has a verified solution.

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

Introduction Since I wrote the original article about Handling Date and Time in PHP and MySQL several years ago, it seemed like now was a good time to update it for object-oriented PHP.  This article does that, replacing as much as possible the pr…
This post looks at MongoDB and MySQL, and covers high-level MongoDB strengths, weaknesses, features, and uses from the perspective of an SQL user.
In this video, Percona Solution Engineer Dimitri Vanoverbeke discusses why you want to use at least three nodes in a database cluster. To discuss how Percona Consulting can help with your design and architecture needs for your database and infras…
In this video, Percona Solutions Engineer Barrett Chambers discusses some of the basic syntax differences between MySQL and MongoDB. To learn more check out our webinar on MongoDB administration for MySQL DBA: https://www.percona.com/resources/we…
Suggested Courses

770 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