python - 在 Django 项目上运行syncdb 不起作用 : Can't create/write to file

Question

当我运行时:

$ python manage.py syncdb

我得到以下输出:

Creating table auth_permission
Traceback (most recent call last):
  File "manage.py", line 11, in <module>
    execute_manager(settings)
  File "/Library/Python/2.6/site-packages/django/core/management/__init__.py", line 362, in execute_manager
    utility.execute()
  File "/Library/Python/2.6/site-packages/django/core/management/__init__.py", line 303, in execute
    self.fetch_command(subcommand).run_from_argv(self.argv)
  File "/Library/Python/2.6/site-packages/django/core/management/base.py", line 195, in run_from_argv
    self.execute(*args, **options.__dict__)
  File "/Library/Python/2.6/site-packages/django/core/management/base.py", line 222, in execute
    output = self.handle(*args, **options)
  File "/Library/Python/2.6/site-packages/django/core/management/base.py", line 351, in handle
    return self.handle_noargs(**options)
  File "/Library/Python/2.6/site-packages/django/core/management/commands/syncdb.py", line 78, in handle_noargs
cursor.execute(statement)
  File "/Library/Python/2.6/site-packages/django/db/backends/util.py", line 19, in execute
    return self.cursor.execute(sql, params)
  File "/Library/Python/2.6/site-packages/django/db/backends/mysql/base.py", line 84, in execute
    return self.cursor.execute(query, args)
  File "build/bdist.macosx-10.6-universal/egg/MySQLdb/cursors.py", line 173, in execute
  File "build/bdist.macosx-10.6-universal/egg/MySQLdb/connections.py", line 36, in defaulterrorhandler
_mysql_exceptions.InternalError: (1, "Can't create/write to file '/usr/local/mysql/data/wzhere/auth_permission.MYI' (Errcode: 2)")

关于如何调试有什么想法吗？我已授予数据库用户所需的所有权限。不确定 MySQL 在这里犹豫什么。

更新:这里的问题最终是我安装了MySQL多次(首先是32位，然后是64位，当我意识到我应该这样做时)，尽管我遵循了一些说明关于如何卸载 MySQL，Snow Leopard 的说明略有不同。一旦我真正卸载并全新安装，这个问题就消失了。

Answer 1

问题是如何调试问题，正如 Agos 已经指出的，Errno 2 是“没有这样的文件或目录”。您可能想查看 MySQL 的数据目录并检查该目录是否确实存在并且具有正确的权限

shell> cd /usr/local/mysql/data/
shell> ls -ld *
drwx------    17 geert   admin         578 Oct  1 19:33 someabstract

上面应该给你目录列表(这是 MySQL 数据库)及其权限。检查 'wzhere' 目录是否特别..我应该说，你收到的错误消息有点奇怪。

(在这种情况下尝试另一个 Django DB 后端无法解决任何问题。)