Solved

Cannot start server instance MySQL

Posted on 2008-10-26
7
2,516 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
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
PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

 
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

Enterprise Mobility and BYOD For Dummies

Like “For Dummies” books, you can read this in whatever order you choose and learn about mobility and BYOD; and how to put a competitive mobile infrastructure in place. Developed for SMBs and large enterprises alike, you will find helpful use cases, planning, and implementation.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
change database name 2 36
Display images from mysql blob type (Not working) 9 43
MySQL Sub-Select Query Returning Duplicate Result 7 45
Very Large data in MYSQL 7 73
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…
Load balancing is the method of dividing the total amount of work performed by one computer between two or more computers. Its aim is to get more work done in the same amount of time, ensuring that all the users get served faster.
Although Jacob Bernoulli (1654-1705) has been credited as the creator of "Binomial Distribution Table", Gottfried Leibniz (1646-1716) did his dissertation on the subject in 1666; Leibniz you may recall is the co-inventor of "Calculus" and beat Isaac…

829 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