Jump to content

Archived

This topic is now archived and is closed to further replies.

billybob013

Newbie...WAMP: mysql will not run

Recommended Posts

[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]

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)




[b]Also in the "mysql error log" this is what is happening:[/b]

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

Share this post


Link to post
Share on other sites
Sounds like the server was started twice -- a no-no with InnoDB tables, as they can get very unhappy.

Share this post


Link to post
Share on other sites

×

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.