How to reset db in Django I get a command reset not found error

Question

Following this Django by Example tutotrial here  http   lightbird net dbe todo list html  The tutorial says       This changes our table layout and we   ll have to ask Django to reset   and recreate tables       manage py reset todo  manage py syncdb    though  when I run manage py reset todo  I get the error     python manage py reset todo                                        - Unknown command   reset    Is this because I am using sqlite3 and not postgresql   Can somebody tell me what the command is to reset the database   The command  python manage py sqlclear todo returns the error     python manage py sqlclear todo     CommandError  App with label todo could not be found      Are you sure your INSTALLED APPS setting is correct    So I added  todo  to my INSTALLED APPS in settings py  and ran python manage py sqlclear todo again  resulting in this error     python manage py sqlclear todo                                       - NameError  name  admin  is not defined

User · Answer

python manage py flush   deleted old db contents    Don t forget to create new superuser   python manage py createsuperuser

User · Answer

reset has been replaced by flush with Django 1 5  see    python manage py help flush

User · Answer

With django 1 11  simply delete all migration files from the migrations folder of each application  all files except   init   py   Then   Manually drop database  Manually create database  Run python3 manage py makemigrations  Run python3 manage py migrate    And voilla  your database has been completely reset

User · Answer

Just manually delete you database  Ensure you create backup first  in my case db sqlite3 is my database  Run this command manage py migrate

User · Answer

Similar to LisaD s answer  Django Extensions has a great reset db command that totally drops everything  instead of just truncating the tables like  flush  does   python   manage py reset db  Merely flushing the tables wasn t fixing a persistent error that occurred when I was deleting objects  Doing a reset db fixed the problem

User · Answer

If you want to clean the whole database  you can use  python manage py flush If you want to clean database table of a Django app  you can use  python manage py migrate appname zero

User · Answer

It looks like the  flush  answer will work for some  but not all cases   I needed not just to flush the values in the database  but to recreate the tables properly   I m not using migrations yet  early days  so I really needed to drop all the tables     Two ways I ve found to drop all tables  both require something other than core django   If you re on Heroku  drop all the tables with pg reset   heroku pg reset DATABASE URL heroku run python manage py syncdb   If you can install Django Extensions  it has a way to do a complete reset     python   manage py reset db --router default

User · Answer

For me this solved the problem   heroku pg reset DATABASE URL  heroku run bash  gt  gt  Inside heroku bash cd app name  amp  amp  rm -rf migrations  amp  amp  cd      manage py makemigrations app name   manage py migrate

User · Answer

if you are using Django 2 0 Then  python manage py flush    will work

User · Answer

Just a follow up to  LisaD s answer  As of 2016  Django 1 9   you need to type   heroku pg reset DATABASE URL heroku run python manage py makemigrations heroku run python manage py migrate   This will give you a fresh new database within Heroku

[python] How to reset db in Django? I get a command 'reset' not found error

Examples related to python

Examples related to database

Examples related to django

Examples related to reset