WampServer

HI, i've been running on wamp for a several months. Suddenly wamp can't start mysql service. I tried to reinstall wamp twice and the same error showed up again.
log tells this:
070707 18:58:34 InnoDB: Error: unable to create temporary file; errno: 22
070707 18:58:34 [ERROR] Default storage engine (InnoD is not available
070707 18:58:34 [ERROR] Aborting
Is there a way to solve this? I'd appreciate any help.
Thanks much!

im not sure if this is the same problem but i have been haveing this error as of late and not sure why

070709 19:57:45 InnoDB: Started; log sequence number 0 54455
070709 19:57:45 [ERROR] Do you already have another mysqld server running on port: 3306 ?
070709 19:57:45 [ERROR] Aborting

070709 19:57:45 InnoDB: Starting shutdown...
070709 19:57:48 InnoDB: Shutdown completed; log sequence number 0 54455
070709 19:57:48 [Note] c:\wamp\mysql\bin\mysqld-nt.exe: Shutdown complete


any way for me to find out what would be causeing this? as far as i know i dont have another mysql server running. I havent instaled anything new in awhile now other then testing out apples new safari for windows(lol). so any help would be nice

i was brought here by google...
I had the same problem, and by reading the .err file in "\MySQL\MySQL Server 5.0\data" it said that it was unable to create "temporary file". Through searching I saw that MySQL accesses a temporary folder to stash all temporary files. This folder is accessed by the environment variable "TMPDIR" which might not exist yet, and if does not exists, it will create its own folder but unfortunately it will use a folder with unix notation, w/c does not exists in windows environment.

Therefore you must create your own TMPDIR environmental variable by using SET command in DOS or System Properties. Then filling the variable with a string which is the absolute path of the temporary folder. For this to work, the folder must also be created first. Apparently, MySQL can't see if the folder exist or not therefore it only returns an error. ^_^

Hope this helps! <bluehunter.06@gmail.com>

I set this variable in system properties, but it doesn't help (tried both - system and user variables). Same error

Open my.ini in c:/wamp/mysql and set absolute path for tmpdir to c:/wamp/tmp

I've never try this but this seems working for some people here

Have fun,

[www.jlbn.net]

I didn't find any reference to tempdir in my.ini, so I added line: tmpdir=c:/wamp/tmp as you advised and it worked. Thanks a lot for help



Post Edited (07-13-07 18:52)