Django Error code 28 while synchronizing the database (MySQL) -
in django create new models in existing database. while synchronizing models displays error. cannot fix these problem. i'm using mysql database. added error code. kindly share ideas.
python manage.py syncdb creating tables ... creating table registration_securityquestions traceback (most recent call last): file "manage.py", line 14, in <module> execute_manager(settings) file "/usr/local/lib/python2.7/dist-packages/django/core/management/__init__.py", line 459, in execute_manager utility.execute() file "/usr/local/lib/python2.7/dist-packages/django/core/management/__init__.py", line 382, in execute self.fetch_command(subcommand).run_from_argv(self.argv) file "/usr/local/lib/python2.7/dist-packages/django/core/management/base.py", line 196, in run_from_argv self.execute(*args, **options.__dict__) file "/usr/local/lib/python2.7/dist-packages/django/core/management/base.py", line 232, in execute output = self.handle(*args, **options) file "/usr/local/lib/python2.7/dist-packages/django/core/management/base.py", line 371, in handle return self.handle_noargs(**options) file "/usr/local/lib/python2.7/dist-packages/django/core/management/commands/syncdb.py", line 102, in handle_noargs cursor.execute(statement) file "/usr/local/lib/python2.7/dist-packages/django/db/backends/util.py", line 40, in execute return self.cursor.execute(sql, params) file "/usr/local/lib/python2.7/dist-packages/django/db/backends/mysql/base.py", line 114, in execute return self.cursor.execute(query, args) file "/usr/lib/python2.7/dist-packages/mysqldb/cursors.py", line 174, in execute self.errorhandler(self, exc, value) file "/usr/lib/python2.7/dist-packages/mysqldb/connections.py", line 36, in defaulterrorhandler raise errorclass, errorvalue django.db.utils.databaseerror: (3, "error writing file './userregdb/registration_securityquestions.frm' (errcode: 28)")
from mysql doc:
the preceding error typical message windows; unix message similar.
one fix start mysqld --tmpdir
option or add option [mysqld]
section of option file. example, specify directory of c:\temp
, use these lines:
[mysqld] tmpdir=c:/temp
Comments
Post a Comment