First time here? Check out the FAQ!

There hasn't database file?

There isn't whole database dump file in the project. I used script " syncdb" couldn't dump all tables.

suyu8776's avatar
asked 2010-12-09 00:58:18 -0500
edit flag offensive 0 remove flag close merge delete


add a comment see more comments

1 Answer


Hello there. In addition to syncdb please run

python migrate

That will complete the database initialization. It is actually described in the manual. There is a link "install/docs" above in the header.

Tables for "askbot" and the login app "django_authopenid" are managed by the database migration system called "South" which provides management command migrate.

This greatly helps in upgrading the database schema.

Note that if you have other apps under the same migration system you might want to instead specify which application to migrate.

Evgeny's avatar
updated 2010-12-09 02:27:45 -0500, answered 2010-12-09 01:20:56 -0500
edit flag offensive 0 remove flag delete link


Yes,i use " migrate",and then another error occur:_mysql_exceptions.OperationalError: (1025, "Error on rename of '.\\cnprog\\#sql-b4c_a0' to '.\\cnprog\\django_authopenid_userassociation' (errno: 150)")
suyu8776's avatar suyu8776 (2010-12-09 02:29:52 -0500) edit
Just guessing - maybe your MySQL uses InnoDB backend? I have not tested with that. Will try tomorrow. Could you try MyISAM storage? With InnoDB and others there will be problems with the full text search. Can you please also post entire stacktrace and the version of MySQL? And you could also try PostgreSQL, it is actually better.
Evgeny's avatar Evgeny (2010-12-09 02:56:27 -0500) edit
Yes,you are right,when i change the MySQL engine to MyISAM,there is no this error and everything is ok.Thanks!
suyu8776's avatar suyu8776 (2010-12-09 08:47:01 -0500) edit
add a comment see more comments