How to migrate back from initial migration in Django 1.7?

Question

I created a new app with some models and now I noticed that some of the models are poorly thought out. As I haven't committed the code the sensible thing would be to migrate the database to last good state and redo the migration with better models. In this case the last good state is database where the new app doesn't exist.

How can I migrate back from initial migration in Django 1.7?

In South one could do:

python manage.py migrate <app> zero

Which would clear <app> from migration history and drop all tables of <app>.

How to do this with Django 1.7 migrations?

This is a case of you should have tried the command you wrote here. The answer and comment in it is pretty much a copy of this. — Akaisteph7, Aug 10 '23 at 14:22

score 253 · Accepted Answer · edited Apr 19 '18 at 20:11

253

You can do the same with Django 1.7+ also:

python manage.py migrate <app> zero

This clears <app> from migration history and drops all tables of <app>

See django docs for more info.

edited Apr 19 '18 at 20:11

supervacuo

9,072
2
44
61

answered Sep 01 '14 at 14:25

Chillar Anand

27,936
9
119
136

7

Is this documented anywhere? The django documentation on migrations is severely lacking... – rnevius Mar 25 '15 at 10:57
2

Doc can be found in the django-admin and manage.py documentation page: https://docs.djangoproject.com/en/1.7/ref/django-admin/#django-admin-migrate – n__o Jul 31 '15 at 05:50
@n__o Thanks. Updated answer. – Chillar Anand Jul 31 '15 at 06:11
1

How would you handle IntegrityError: NOT NULL constraint failed? – wasabigeek Aug 26 '15 at 15:23
it gives *Access is denied* – Naila Akbar Apr 26 '16 at 11:07
2

Just tried this on Django 1.9 and it worked fine as well. Thanks – Dário Jul 22 '16 at 12:39
This indeed dropped all tables and migration history, but it did not delete my `0001_initial.py` migration file. Could you please confirm whether I should manually delete it or not? – sc28 Feb 20 '19 at 14:52
@sc28 Those can be manually deleted, edited, left, whatever you like. – Akaisteph7 Aug 10 '23 at 14:24

score 7 · Answer 2 · edited Oct 17 '15 at 17:25

7

you can also use the version number:

python manage.py migrate <app> 0002

Source: https://docs.djangoproject.com/en/1.7/ref/django-admin/#django-admin-migrate

edited Oct 17 '15 at 17:25

Community

1
1

answered Jul 28 '15 at 16:42

jsh

1,995
18
28

12

The question asked is about migrating back from the *initial* migration, and using `0000` does not work – gdvalderrama Dec 22 '17 at 09:39
i see, i may have misunderstood the question (although it's not particularly well written IMHO). why wouldn't you just drop the DB? oh well – jsh Feb 22 '18 at 22:02
6

dropping the whole DB for one table is a bit overkill – gdvalderrama Feb 23 '18 at 08:30

How to migrate back from initial migration in Django 1.7?

2 Answers2

Linked

Related