If you do not want to use InnoDB at all, add this line to /etc/my.cnf under the [mysqld] section skip_innodb
Then do the following service mysql stop rm -f /var/lib/mysql/ibdata1 /var/lib/mysql/ib_logfile[01] service mysql start This will totally and cleanly disable InnoDB on the DB server Give it a try !!! Rolando A. Edwards MySQL DBA (CMDBA) 155 Avenue of the Americas, Fifth Floor New York, NY 10013 212-625-5307 (Work) 201-660-3221 (Cell) AIM & Skype : RolandoLogicWorx redwa...@logicworks.net -----Original Message----- From: malki.cymbali...@weizmann.ac.il [mailto:malki.cymbali...@weizmann.ac.il] Sent: Monday, June 08, 2009 10:02 AM To: mysql@lists.mysql.com Cc: shlomit.af...@weizmann.ac.il Subject: MySQL error We are running MySQL 5.0.45 on a Linux machine. Today, when I tried to go into MySQL via the command line, I got an error message: Can't connect to local MySQL server through socket '/usr/local/mysql/tmp/mysql.sock' The error log was full of the following messages: InnoDB: Unable to lock ./ibdata1, error: 11 InnoDB: Check that you do not already have another mysqld process InnoDB: using the same InnoDB data or log files. We stopped MySQL and started it again and everything seems to be working. However, we would like to understand what happened. The strange thing here is that we are not using InnoDB tables so we don't understand why we are getting InnoDB errors and what it is trying to do with the ibdata1 file. We do have an ibdata1 file and ib_logfile files. Could it be that we are using InnoDB tables and we don't realize it? Could we have made a mistake somewhere? Is there a way to check this? Can we erase these files? Any help will be appreciated. Malki Cymbalista Webmaster, Weizmann Institute of Science Rehovot, Israel 76100 Internet: malki.cymbali...@weizmann.ac.il -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/mysql?unsub=redwa...@logicworks.net -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/mysql?unsub=arch...@jab.org
