How do you remove all data after running syncdb?

Question

I'm in production and just ran syncdb but I made a mistake and want to delete what syncdb did, including all data in the tables is fine. Just a fresh start in the databases so I can run syncdb again.

(virtualenv-2.7)[root@server mysite]# python manage.py sqlclear mainapp | python manage.py dbshell
CommandError: One or more models did not validate:
app.comment: 'poster' defines a relation with the model 'auth.User', which has been swapped out. Update the relation to point at settings.AUTH_USER_MODEL.
app.myuser: The field named as the USERNAME_FIELD should not be included in REQUIRED_FIELDS on a swappable User model.

What kind of database are you using (MySQL, Postgres... etc)? — Daniel Robinson, Jan 16 '15 at 05:47
`drop database whatever_your_database_name; create databse whatever_your_database_name;`? — J0HN, Jan 16 '15 at 06:08
@Raja what do you mean? I've made some changes and want to populate them from fresh. I might try JOHN solution — User, Jan 16 '15 at 13:51

score 0 · Answer 1 · answered Jan 16 '15 at 06:54

0

Recreate database is probably the best way. Also you can do it using reset_db management command from django-extensions package.

answered Jan 16 '15 at 06:54

likeon

791
1
6
19

gshmu · Answer 2 · 2015-01-16T09:46:09.723

0

The Django 1.7 support migrate you just run python manage.py migrate again after edit. more features to see: release note

edited Jan 16 '15 at 09:46

answered Jan 16 '15 at 07:49

gshmu

1
2

score 0 · Accepted Answer · answered Jan 18 '15 at 19:35

As J0HN stated in the comments, the best thing to do to start fresh was to actually just delete the database. I thought it might mess something up, but it won't. Simply login to mysql.

drop database whatever_your_database_name;
create databse whatever_your_database_name;

Then simply sync it again with python manage.py syncdb

score 0 · Answer 4 · answered Jan 18 '15 at 19:49

0

Maybe its lazy, but I run:

django-admin.py reset_db --router=default --noinput

answered Jan 18 '15 at 19:49

sahutchi

2,223
2
19
20

How do you remove all data after running syncdb?

4 Answers4