django mysql syncdb doesn't create tables in models.py

Question

I have a server using django. I'm trying to switch my database from sqlite3 to mysql. Everything worked fine with sqlite3 before. However, when I use mysql and do

python manage.py syncdb

I didn't get any error, but the tables specified in models.py are not created. Only the following tables are created:

[ec2-user@domU-12-31-39-0F-D2-F3 prototype]$ python manage.py syncdb
Syncing...
Creating tables ...
Creating table auth_permission
Creating table auth_group_permissions
Creating table auth_group
Creating table auth_user_user_permissions
Creating table auth_user_groups
Creating table auth_user
Creating table django_content_type
Creating table django_session
Creating table django_site
Creating table django_admin_log
Creating table south_migrationhistory

Anyone know why?

See the answer: http://stackoverflow.com/a/27204663 – Rafiq Nov 29 '14 at 17:29 — Rafiq, Nov 29 '14 at 17:29

score 5 · Accepted Answer · answered May 09 '13 at 16:17

5

It looks like you are using South. Normally South would inhibit the creation of most tables in the syncdb, and you'd be expected to run your South migrations to create them for the first time. This is so South can keep track of the state of your tables and apply any special migration rules you have, even initially.

The other possibility is that you don't have all of your apps listed in your INSTALLED_APPS variable in the settings file.

answered May 09 '13 at 16:17

Andrew Gorcester

19,595
7
57
73

Yeah you are right. It was because of South. I reset the south database and then did a syncdb again. It worked. Thanks! – zhengwx May 09 '13 at 16:18

score 3 · Answer 2 · answered May 09 '13 at 16:18

3

You have south installed.

When you run python manage.py syncdb it syncs all the non-south managed apps.

run python manage.py migrate to sync the other apps.

this is a tutorial I ran some of my coworkers through (the official south docs are more in depth, I had 15 minutes to get them on south and productive): https://gist.github.com/fyaconiello/2423447

answered May 09 '13 at 16:18

Francis Yaconiello

10,829
2
35
54

Yeah this is the problem. I figured it out. Thanks! – zhengwx May 09 '13 at 16:21

score 0 · Answer 3 · answered Feb 22 '14 at 00:11

0

It might be also the case that you inherited your model class from object and not from models.Model

The table will not be created. And no error will be raised

answered Feb 22 '14 at 00:11

jdcaballerov

1,452
1
12
16

score 0 · Answer 4 · answered Sep 30 '14 at 14:20

I found another solution:

create another database, for example db2
change your DATABASES['default'] in settings point to this db
for the latest Django version just run python manage.py migrate

This will create new and clear db structure

You need to move needed tables, for mysql: ALTER table db1.table_name RENAME db2.table_name

Thats all, thanks

django mysql syncdb doesn't create tables in models.py

4 Answers4