tags:

views:

410

answers:

1

Hi everyone, I'm having issues creating a table for my ruby on rails app. It's driving me crazy! The following is returned when I try to create the table:

ERROR 1 (HY000): Can't create/write to file '/usr/local/mysql/data/test_development/users.MYI' (Errcode: 2)

It's worth mentioning I'm a total newbie, btw.

A: 

This forum post seems to deal with the same problem:

Try the following:

  1. mkdir /var/lib/mysql/tmp
  2. chmod mysql:mysql /var/lib/mysql/tmp
  3. Add the following line into the [mysqld] section: tmpdir = /var/lib/mysql/tmp
  4. Restart the server
Dave Swersky
Hi Dave, thanks for responding. Unfortunately that doesn't seem to work for me.ashley_baxter$ mkdir /var/lib/mysql/tmpmkdir: /var/lib/mysql: No such file or directoryI've managed to get everything working nicely on my iMac, but it's my MacBook that's giving me grief. Not sure why as I've followed the same steps.