billybob013 Posted February 13, 2006 Share Posted February 13, 2006 [b]I have just downloaded WAMP and when I try to run MySql is disconnects after a couple of seconds. I view my phpMyAdmin localhost page and on the left side of the screen it displays:[/b]ErrorSQL query: SELECT COUNT( * ) AS numFROM `information_schema`.`COLUMNS` MySQL said: #1 - Can't create/write to file 'C:\Program Files\xampp\tmp\#sql_608_0.MYI' (Errcode: 2) [b]Also in the "mysql error log" this is what is happening:[/b]060212 18:03:17 InnoDB: Started; log sequence number 0 43655060212 18:03:17 [ERROR] Do you already have another mysqld server running on port: 3306 ?060212 18:03:17 [ERROR] Aborting060212 18:03:17 InnoDB: Starting shutdown...060212 18:03:19 InnoDB: Shutdown completed; log sequence number 0 43655060212 18:03:19 [Note] c:\wamp\mysql\bin\mysqld-nt.exe: Shutdown complete Thanks, bill Quote Link to comment Share on other sites More sharing options...
fenway Posted February 13, 2006 Share Posted February 13, 2006 Sounds like the server was started twice -- a no-no with InnoDB tables, as they can get very unhappy. Quote Link to comment Share on other sites More sharing options...
billybob013 Posted February 13, 2006 Author Share Posted February 13, 2006 Fixed problem, Thanks, Fenway Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.