There hasn't database file?

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

suyu8776
11 ●3 ●2 ●3

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

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

Evgeny

14295 ●56 ●103 ●216 http://askbot.org/

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

Hello there. In addition to syncdb please run

python manage.py 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

Comments

Yes,i use "manage.py 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 ( 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 ( 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 ( 2010-12-09 08:47:01 -0600 )edit

add a comment

Your Answer

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

Add Answer

There hasn't database file?

1 Answer

Comments

Your Answer

Question Tools

Stats

Related questions

There hasn't database file? edit

1 Answer

Comments

Your Answer

Question Tools

Stats

Related questions

There hasn't database file?