Go to Topic: Previous•Next
Go to: Forum List•Message List•New Topic•Search•Log In•Print View
MYSQL Wont Stay Started/ Resumed
Posted by: cruthas (---.hsd1.co.comcast.net)
Date: February 25, 2008 04:52AM

I have everything working, Localhost loads up, PhPmyAdmin loads u, SQLite Manager Loads up. Everything seems to be working fine but when I go to start/resume mysql it starts for a couple seconds then stops. The meter in the right hand corner goes white then back to yellow. When I try to start all services at once samething happens. Not really sure what do do next. I have restart the computer, Wamp5 and nothing seems to make a difference. Any help would be great.

Options: Reply•Quote
Re: MYSQL Wont Stay Started/ Resumed
Posted by: cruthas (---.hsd1.co.comcast.net)
Date: February 25, 2008 05:09AM

This is my Log

InnoDB: The first specified data file .\ibdata1 did not exist:
InnoDB: a new database to be created!
080224 18:44:11 InnoDB: Setting file .\ibdata1 size to 10 MB
InnoDB: Database physically writes the file full: wait...
080224 18:44:12 InnoDB: Log file .\ib_logfile0 did not exist: new to be created
InnoDB: Setting log file .\ib_logfile0 size to 10 MB
InnoDB: Database physically writes the file full: wait...
080224 18:44:13 InnoDB: Log file .\ib_logfile1 did not exist: new to be created
InnoDB: Setting log file .\ib_logfile1 size to 10 MB
InnoDB: Database physically writes the file full: wait...
InnoDB: Doublewrite buffer not found: creating new
InnoDB: Doublewrite buffer created
InnoDB: Creating foreign key constraint system tables
InnoDB: Foreign key constraint system tables created
080224 18:44:15 InnoDB: Started; log sequence number 0 0
080224 18:44:15 [ERROR] Do you already have another mysqld server running on port: 3306 ?
080224 18:44:16 [ERROR] Aborting

080224 18:44:16 InnoDB: Starting shutdown...
080224 18:44:23 InnoDB: Shutdown completed; log sequence number 0 43655
080224 18:44:23 [Note] wampmysqld: Shutdown complete

080224 18:44:49 InnoDB: Started; log sequence number 0 43655
080224 18:44:49 [ERROR] Do you already have another mysqld server running on port: 3306 ?
080224 18:44:49 [ERROR] Aborting

080224 18:44:49 InnoDB: Starting shutdown...
080224 18:44:53 InnoDB: Shutdown completed; log sequence number 0 43655
080224 18:44:53 [Note] wampmysqld: Shutdown complete

080224 18:47:13 InnoDB: Started; log sequence number 0 43655
080224 18:47:13 [ERROR] Do you already have another mysqld server running on port: 3306 ?
080224 18:47:13 [ERROR] Aborting

Options: Reply•Quote
Re: MYSQL Wont Stay Started/ Resumed
Posted by: yfastud (Moderator)
Date: February 25, 2008 05:25AM

Quote

080224 18:44:15 [ERROR] Do you already have another mysqld server running on port: 3306 ?
Did you ever have any database server before? If not, try this

Left click on wamp tray icon, then MySQL, then my.ini

Find:
default-storage-engine=InnoDB

Change to:
default-storage-engine=MyISAM

Restart wamp to take effect

Have fun,

FREE One A Day
FREE Photo
FREE Games
FREE Websites
FREE Portable GPS
FREE WAMP Guides

Options: Reply•Quote
Re: MYSQL Wont Stay Started/ Resumed
Posted by: cruthas (---.hsd1.co.comcast.net)
Date: February 25, 2008 06:39AM

I changed it and still same result and the log sequence is the same.

Options: Reply•Quote
Re: MYSQL Wont Stay Started/ Resumed
Posted by: yfastud (Moderator)
Date: February 25, 2008 01:58PM

That's why I've asked if you've ever had any db before?

Have fun,

FREE One A Day
FREE Photo
FREE Games
FREE Websites
FREE Portable GPS
FREE WAMP Guides

Options: Reply•Quote
Re: MYSQL Wont Stay Started/ Resumed
Posted by: cruthas (---.hsd1.co.comcast.net)
Date: February 25, 2008 02:26PM

no never had a db.

Options: Reply•Quote
Re: MYSQL Wont Stay Started/ Resumed
Posted by: cruthas (---.hsd1.co.comcast.net)
Date: February 25, 2008 06:57PM

I figured it out. I never closed and restarted mysql from the operation menu.
Thanks for your help I did what you said and it worked.

Options: Reply•Quote
Re: MYSQL Wont Stay Started/ Resumed
Posted by: yfastud (Moderator)
Date: February 25, 2008 07:13PM

youre welcome anytime :-)

Have fun,

FREE One A Day
FREE Photo
FREE Games
FREE Websites
FREE Portable GPS
FREE WAMP Guides

Options: Reply•Quote


Go to: Forum List•Message List•Search•Log In
Sorry, only registered users may post in this forum.
Click here to login