Ask Your Question

There hasn't database file?

asked 2010-12-09 00:58:18 -0600

suyu8776's avatar

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

edit retag flag offensive close merge delete

1 Answer

Sort by ยป oldest newest most voted

answered 2010-12-09 01:20:56 -0600

Evgeny's avatar

updated 2010-12-09 02:27:45 -0600

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.

edit flag offensive delete link more


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 -0600 )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 -0600 )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 -0600 )edit

Your Answer

Please start posting anonymously - your entry will be published after you log in or create a new account.

Add Answer

Question Tools


Asked: 2010-12-09 00:58:18 -0600

Seen: 192 times

Last updated: Dec 09 '10