scottybwoy Posted June 6, 2008 Share Posted June 6, 2008 Hi I'm trying to install MySQL 5.1.26 on Windows Pro sp4 and it just won't work. At the moment after typing "mysqld" --console it returns : 080606 10:58:21 [Warning] Can't create test file C:\MySQL\data\com3.lower-test 080606 10:58:21 [Warning] Can't create test file C:\MySQL\data\com3.lower-test 080606 10:58:21 InnoDB: Error: unable to create temporary file; errno: 2 080606 10:58:21 [ERROR] Plugin 'InnoDB' init function returned error. 080606 10:58:21 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed. 080606 10:58:21 [ERROR] Unknown/unsupported table type: INNODB 080606 10:58:21 [ERROR] Aborting 080606 10:58:21 [Note] mysqld: Shutdown complete The MySQL website is rubbish for finding answers and haven't found a satisfactory one elsewhere, but I know the guys on here are really good so thought you might be able help. Thanks in advance Quote Link to comment Share on other sites More sharing options...
fenway Posted June 6, 2008 Share Posted June 6, 2008 Write permissions? Quote Link to comment Share on other sites More sharing options...
scottybwoy Posted June 6, 2008 Author Share Posted June 6, 2008 No Checked that it's open to everyone. 777 Apparently according to MySQL it doesn't really matter about the temp files. But the INNODB is the problem Quote Link to comment Share on other sites More sharing options...
fenway Posted June 6, 2008 Share Posted June 6, 2008 No Checked that it's open to everyone. 777 Apparently according to MySQL it doesn't really matter about the temp files. But the INNODB is the problem According to the refman page, it is a write permission issue, and has nothing to do with innodb.... But your second problem does... what version? Sounds like you have --skip-innodb... what does SHOW ENGINES say? Quote Link to comment Share on other sites More sharing options...
scottybwoy Posted June 10, 2008 Author Share Posted June 10, 2008 OK, sorry for my impatience waiting for your response. But I have since installed it on practically a fresh install of Win XP SP2, and am getting similar problems. The one I am having now is... 080610 13:36:07 InnoDB: Started; log sequence number 0 46409 080610 13:36:07 [ERROR] C:\MySQL51\bin\mysqld: Can't create/write to file 'C:\Do cuments and Settings\All Users\Application Data\MySQL\MySQL Server 5.1\data\com4.pid' (Errcode: 2) Can't start server: can't create PID file: No such file or directory This location is available and has all the write permissions. I am using MySQL version 5.1 windows XP installer. Are their any known problems with installing on a local web development machine within a domain? Thanks for your time. Quote Link to comment Share on other sites More sharing options...
scottybwoy Posted June 10, 2008 Author Share Posted June 10, 2008 Don't worry worked it out. Computer was called COM4, I changed it to another name and it now works! Quote Link to comment Share on other sites More sharing options...
fenway Posted June 11, 2008 Share Posted June 11, 2008 Don't worry worked it out. Computer was called COM4, I changed it to another name and it now works! Wow... using a port handle as a computer name... yeesh. 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.