There hasn't database file?

Question

asked Dec 09 '10

suyu8776
11 ● 1

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

Answer 1

answered Dec 09 '10

Evgeny

6665 ● 31 ● 49 ● 95
http://askbot.org/

updated Dec 09 '10

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.

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 (Dec 09 '10)
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 (Dec 09 '10)
Yes,you are right,when i change the MySQL engine to MyISAM,there is no this error and everything is ok.Thanks! suyu8776 (Dec 09 '10)

There hasn't database file?

1 Answer

Comments

Your answer

Question tools

Stats

Related questions