This is a problem related to Innodb and MyISAM. Django uses this latter, while probably your imported DB is an Innodb one. Check here https://docs.djangoproject.com/en/dev/ref/databases/ Search Google for the matter too, you are not the only one experiencing it.
I would suggest getting rid of the new tables you created, switching to InnoDB and migrating everything. Try and let me know. Leo 2011/10/27 Daniele Procida <dani...@vurt.org>: > I keep getting errors like this: > > _mysql_exceptions.OperationalError: (1005, "Can't create table > 'arkestra_medic_dev.#sql-51b_4a8' (errno: 150)") > > when running database management commands (syncdb, south migrate). > > Sometimes those commands work, sometimes they don't; it happens across a > variety of apps. > > I am working on a database that was exported from one system and has been > imported into a new one. > > Running Django 1.3.1. I'm pretty sure the issue is something to do with my > database/setup, rather than anything in the apps involved. > > Any suggestions greatly appreciated. > > Daniele > > > -- > You received this message because you are subscribed to the Google Groups > "Django users" group. > To post to this group, send email to django-users@googlegroups.com. > To unsubscribe from this group, send email to > django-users+unsubscr...@googlegroups.com. > For more options, visit this group at > http://groups.google.com/group/django-users?hl=en. > > -- You received this message because you are subscribed to the Google Groups "Django users" group. To post to this group, send email to django-users@googlegroups.com. To unsubscribe from this group, send email to django-users+unsubscr...@googlegroups.com. For more options, visit this group at http://groups.google.com/group/django-users?hl=en.
