- PHP, Apache, MySQL, Windows : WampServer

Go to: Forum List•Message List•New Topic•Search•Log In•Print View

MYSQL keeps crashing on startup -Windows 7 64bit

Posted by: rweiss23 (---.hsd1.ma.comcast.net)

Date: February 04, 2013 04:24PM

I have been going crazy trying to get WAMP to work. My old version used to work fine, but the new one just won't get up and going. The problem seems to be MYSQL. After reading the forum, I figured I might have an old instance running, so I've deleted everyone I could find. I went into services and disabled MYSQL startup there, as its pointing to an old/deleted folder.
Here are the stats:
----------------------------------------------------
wampserver2.2e-php5.4.3-httpd2.2.22-mysql5.5.24-x64
----------------------------------------------------
MYSQL error log:
130204 10:12:54 [Note] Plugin 'FEDERATED' is disabled.
130204 10:12:54 InnoDB: The InnoDB memory heap is disabled
130204 10:12:54 InnoDB: Mutexes and rw_locks use Windows interlocked functions
130204 10:12:54 InnoDB: Compressed tables use zlib 1.2.3
130204 10:12:54 InnoDB: Initializing buffer pool, size = 107.0M
130204 10:12:54 InnoDB: Completed initialization of buffer pool
130204 10:12:54 InnoDB: highest supported file format is Barracuda.
130204 10:12:55 InnoDB: Waiting for the background threads to start
130204 10:12:56 InnoDB: 1.1.8 started; log sequence number 55829
130204 10:12:56 InnoDB: !!! innodb_force_recovery is set to 4 !!!
130204 10:12:56 [ERROR] wampmysqld: unknown variable 'default-character-set=latin1'
130204 10:12:56 [ERROR] Aborting

130204 10:12:56 InnoDB: Starting shutdown...
130204 10:12:56 InnoDB: Shutdown completed; log sequence number 55829
--------------------------------------------------------------

Obviously, its the - default char set =latin seems to be the culprit. But how to fix it???

Thanks to anybody who can help. This is really slowing down my development work.

Roger

Options: Reply•Quote

Re: MYSQL keeps crashing on startup -Windows 7 64bit

Posted by: stevenmartin99 (Moderator)

Date: February 04, 2013 04:27PM

Search ur PC for my.ini or my.cnf

And delete any that are not in the wamp folder

Steven Martin
stevenmartin99@gmail.com
stevenmartin99@hotmail.com
PampServer.com - [pampserver.com]

Options: Reply•Quote

Re: MYSQL keeps crashing on startup -Windows 7 64bit

Posted by: rweiss23 (---.hsd1.ma.comcast.net)

Date: February 04, 2013 05:19PM

Yes, I've done that. But, the problem persists.
I do agree thats what it looks like, but I can't find the culprit!

Roger

Options: Reply•Quote

Re: MYSQL keeps crashing on startup -Windows 7 64bit

Posted by: stevenmartin99 (Moderator)

Date: February 04, 2013 05:24PM

teamviewer?

Steven Martin
stevenmartin99@gmail.com
stevenmartin99@hotmail.com
PampServer.com - [pampserver.com]

Options: Reply•Quote

Re: MYSQL keeps crashing on startup -Windows 7 64bit