MySQL Help
 
Forums: » Register « |  User CP |  Games |  Calendar |  Members |  FAQs |  Sitemap |  Support | 
User Name:
Password:
Remember me

The Shed is going Social! Join us on FaceBook and Twitter and chime in on the conversation.

Go Back   Dev Shed Forums > Databases > MySQL Help
Reload this Page

Can only start service from CLI


Reply
Add This Thread To:
  Del.icio.us   Digg   Google   Spurl   Blink   Furl   Simpy   Y! MyWeb 
« Previous Thread | Next Thread »  
Thread Tools Search this Thread Rate Thread Display Modes
 
Unread Dev Shed Forums Sponsor:
  #1  
Old January 29th, 2013, 04:28 PM
james1052 james1052 is offline
Registered User
Dev Shed Newbie (0 - 499 posts)
  
Join Date: Jan 2013
Posts: 5 james1052 User rank is Just a Lowly Private (1 - 20 Reputation Level) 
Time spent in forums: 19 m 48 sec
Reputation Power: 0
Can only start service from CLI
I can only start the MySQL service from the command line. Not from the Services snap-in. This is Server 2008. The only way I can start it is by using the CLI to go to the appropriate folder and then running mysqld. From the GUI it just dies. This is a fresh install. Please help!

Thanks!
Reply With Quote
  #2  
Old February 2nd, 2013, 10:13 AM
gw1500se gw1500se is online now
Contributing User
Dev Shed Frequenter (2500 - 2999 posts)
  
Join Date: Jul 2003
Posts: 2,880 gw1500se User rank is Colonel (50000 - 60000 Reputation Level)gw1500se User rank is Colonel (50000 - 60000 Reputation Level)gw1500se User rank is Colonel (50000 - 60000 Reputation Level)gw1500se User rank is Colonel (50000 - 60000 Reputation Level)gw1500se User rank is Colonel (50000 - 60000 Reputation Level)gw1500se User rank is Colonel (50000 - 60000 Reputation Level)gw1500se User rank is Colonel (50000 - 60000 Reputation Level)gw1500se User rank is Colonel (50000 - 60000 Reputation Level)gw1500se User rank is Colonel (50000 - 60000 Reputation Level)gw1500se User rank is Colonel (50000 - 60000 Reputation Level)gw1500se User rank is Colonel (50000 - 60000 Reputation Level)gw1500se User rank is Colonel (50000 - 60000 Reputation Level) 
Time spent in forums: 1 Year 2 Weeks 2 Days 19 h 58 m 37 sec
Reputation Power: 581
This is not really a MySQL question. You need to post this on a Windows Server forum.
__________________
There are 10 kinds of people in the world. Those that understand binary and those that don't.
Reply With Quote
  #3  
Old February 4th, 2013, 09:36 PM
Luis93 Luis93 is offline
Registered User
Dev Shed Newbie (0 - 499 posts)
  
Join Date: Feb 2013
Posts: 4 Luis93 User rank is Just a Lowly Private (1 - 20 Reputation Level) 
Time spent in forums: 26 m 50 sec
Reputation Power: 0
Is the service running under the same account that you are using to start it from the command line? Also is mysql in PATH variable?
Reply With Quote
  #4  
Old February 5th, 2013, 08:20 AM
james1052 james1052 is offline
Registered User
Dev Shed Newbie (0 - 499 posts)
  
Join Date: Jan 2013
Posts: 5 james1052 User rank is Just a Lowly Private (1 - 20 Reputation Level) 
Time spent in forums: 19 m 48 sec
Reputation Power: 0
Yes and yes. I even tried deleting the service and then letting the MySQLInstanceConfig.exe wizard recreate it but no joy.
Reply With Quote
  #5  
Old February 5th, 2013, 08:30 AM
james1052 james1052 is offline
Registered User
Dev Shed Newbie (0 - 499 posts)
  
Join Date: Jan 2013
Posts: 5 james1052 User rank is Just a Lowly Private (1 - 20 Reputation Level) 
Time spent in forums: 19 m 48 sec
Reputation Power: 0
Aha! It only can start the service if I select the "Non-Transactional Database" in the wizard. Otherwise it fails to start the service! Hmmm...
Reply With Quote
  #6  
Old February 5th, 2013, 08:56 AM
james1052 james1052 is offline
Registered User
Dev Shed Newbie (0 - 499 posts)
  
Join Date: Jan 2013
Posts: 5 james1052 User rank is Just a Lowly Private (1 - 20 Reputation Level) 
Time spent in forums: 19 m 48 sec
Reputation Power: 0
Just found these in Event Viewer...So for some reason it doesn't like InnoDB, only MyISAM!!??...

1. Unknown/unsupported storage engine: INNODB
2. Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
3. Plugin 'InnoDB' init function returned error.
Reply With Quote
  #7  
Old February 5th, 2013, 10:07 AM
james1052 james1052 is offline
Registered User
Dev Shed Newbie (0 - 499 posts)
  
Join Date: Jan 2013
Posts: 5 james1052 User rank is Just a Lowly Private (1 - 20 Reputation Level) 
Time spent in forums: 19 m 48 sec
Reputation Power: 0
I think I've fixed it. Finally!... 8P

Per this link...

http: //www firewing1 com /node /17

I deleted the following files...

ib_logfile0
ib_logfile1
ibdata1
$YOUR_HOSTNAME$.err

...from the following paths...

C:\Program Files\MySQL\MySQL Server 5.5\data

C:\ProgramData\MySQL\MySQL Server 5.5\data

Then the wizard let me choose an InnoDB Database and start the service!
Reply With Quote
Reply

Viewing: Dev Shed Forums > Databases > MySQL Help > Can only start service from CLI

« Previous Thread | Next Thread »

Developer Shed Advertisers and Affiliates



Thread Tools  Search this Thread 
Search this Thread:

Advanced Search
Display Modes  Rate This Thread 
Linear Mode Linear Mode
Rate This Thread:


Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts
vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
View Your Warnings | New Posts | Latest News | Latest Threads | Shoutbox
Forum Jump

Forums: » Register « |  User CP |  Games |  Calendar |  Members |  FAQs |  Sitemap |  Support | 
  
 


Powered by: vBulletin Version 3.0.5
Copyright ©2000 - 2013, Jelsoft Enterprises Ltd.

© 2003-2013 by Developer Shed. All rights reserved. DS Cluster - Follow our Sitemap