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

Popular posts from this blog

Detect support for Shoutcast ICY MP3 without navigator.userAgent in Firefox? -

web - SVG not rendering properly in Firefox -

java - JavaFX 2 slider labelFormatter not being used -