Jump to content


Photo

Newbie...WAMP: mysql will not run


  • Please log in to reply
2 replies to this topic

#1 billybob013

billybob013
  • New Members
  • Pip
  • Newbie
  • 4 posts

Posted 13 February 2006 - 12:11 AM

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:

Error
SQL query:

SELECT COUNT( * ) AS num
FROM `information_schema`.`COLUMNS`

MySQL said:

#1 - Can't create/write to file 'C:\Program Files\xampp\tmp\#sql_608_0.MYI' (Errcode: 2)




Also in the "mysql error log" this is what is happening:

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

060212 18:03:17 InnoDB: Starting shutdown...
060212 18:03:19 InnoDB: Shutdown completed; log sequence number 0 43655
060212 18:03:19 [Note] c:\wamp\mysql\bin\mysqld-nt.exe: Shutdown complete



Thanks, bill

#2 fenway

fenway
  • Staff Alumni
  • MySQL Si-Fu / PHP Resident Alien
  • 16,199 posts
  • LocationToronto, ON

Posted 13 February 2006 - 12:42 AM

Sounds like the server was started twice -- a no-no with InnoDB tables, as they can get very unhappy.
Seriously... if people don't start reading this before posting, I'm going to consider not answering at all.

#3 billybob013

billybob013
  • New Members
  • Pip
  • Newbie
  • 4 posts

Posted 13 February 2006 - 02:40 AM

Fixed problem, Thanks, Fenway




0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users