id	summary	reporter	owner	description	type	status	component	version	severity	resolution	keywords	cc	stage	has_patch	needs_docs	needs_tests	needs_better_patch	easy	ui_ux
9348	manage.py reset appname fails to reset MySql database because of foreign key constraints	Jacob Fenwick	nobody	"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."		closed	Core (Management commands)	1.0		duplicate	mysql reset		Unreviewed	0	0	0	0	0	0