manage.py reset appname fails to reset MySql database because of foreign key constraints

[Jacob Fenwick]

I'm running the latest Django from SVN on Windows XP using MySQL as the database.

When I try to reset the database the following happens:

C:\projects\django\foo>python manage.py reset fooapp

You have requested a database reset.
This will IRREVERSIBLY DESTROY any data for
the "fooapp" application in the database "foo".
Are you sure you want to do this?

Type 'yes' to continue, or 'no' to cancel: yes
Error: Error: weather couldn't be reset. Possible reasons:
  * The database isn't running or isn't configured correctly.
  * At least one of the database tables doesn't exist.
  * The SQL was invalid.
Hint: Look at the output of 'django-admin.py sqlreset fooapp'. That's the SQL t
his command wasn't able to run.
The full error: (1217, 'Cannot delete or update a parent row: a foreign key cons
traint fails')

If I run manage.py sqlreset fooapp and copy the generated SQL into the MySQL command line the tables are recreated correctly.

[Jacob Fenwick]

Disregard my comment about the SQL statements working when I pasted them directly into MySQL, they still didn't work.

[Russell Keith-Magee]

Essentially a duplicate of [2493]

[Mike Scott]

Err russel means #2493 not [2493]