Re: Recreate all tables in mysql after dropping the database

2018-09-17 Thread Daniel Roseman
On Monday, 17 September 2018 08:52:32 UTC+1, Joel wrote: > > Thank you. That is how I fixed it yesterday late night after spending > hours on it. > > For anyone else that may find it useful, > I had dropped the tables to fix this. But that ended complaining about > missing tables. Then I dropped

Re: Recreate all tables in mysql after dropping the database

2018-09-17 Thread Joel
Thank you. That is how I fixed it yesterday late night after spending hours on it. For anyone else that may find it useful, I had dropped the tables to fix this. But that ended complaining about missing tables. Then I dropped the database, since all I had was development data. It wouldn't do the m

Re: Recreate all tables in mysql after dropping the database

2018-09-17 Thread Michal Petrucha
-BEGIN PGP SIGNED MESSAGE- Hash: SHA512 Hi Joel, On Sun, Sep 16, 2018 at 10:16:42PM +0530, Joel Mathew wrote: > I tried to fix mysql problems in my database by dropping tables. When that > didnt work, I dropped the database. > I then recreated the database, and tried to run makemigrations

Re: Recreate all tables in mysql after dropping the database

2018-09-16 Thread Mark Phillips
This is how I do it: 1. drop the database 2. create the database. 4. make sure the user identified in your settings.py can still access the database 5. delete the migrations 6. run all migrations Your new db should be populated with all the initial tables. Take a look at this, https://docs.djang

Recreate all tables in mysql after dropping the database

2018-09-16 Thread Joel Mathew
I tried to fix mysql problems in my database by dropping tables. When that didnt work, I dropped the database. I then recreated the database, and tried to run makemigrations. But I am getting errors about missing tables: joel@hp:~/myappointments$ python3 manage.py makemigrations Traceback (most re