Ask Your Question
4

How to edit Django's settings.py file to use MyISAM MySQL storage engine?

asked 2012-06-07 20:10:17 -0600

ubi_com gravatar image

updated 2012-06-07 21:34:19 -0600

Evgeny gravatar image

I want to install askbot on my shared server. The default db engine of this server is InnoDB and .my.cnf is hidden by administrator. I tried to edit the script of askbot to use MyISAM strictly, but I cannot find where to edit. Thanks.

edit retag flag offensive close merge delete

2 Answers

Sort by ยป oldest newest most voted
3

answered 2012-06-07 21:23:42 -0600

Evgeny gravatar image

This stackoverflow post will hopefully help you.

At this time we do not support the "new style" databases settings, use DATABASE_OPTIONS setting instead.

edit flag offensive delete link more

Comments

Thanks a lot! I have achieved to created MyISAM databases to add DATABASE_OPTIONS at settings.py.

ubi_com gravatar imageubi_com ( 2012-06-12 18:33:38 -0600 )edit
-1

answered 2012-06-10 07:02:50 -0600

naavi gravatar image

If you own the box, why not make MyIsam default globally across all apps?

Add the following directive to /etc/my.cnf

default-storage-engine = MyISAM

edit flag offensive delete link more

Comments

I'm not alone to use this machine.

ubi_com gravatar imageubi_com ( 2012-06-12 18:38:23 -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

Stats

Asked: 2012-06-07 20:10:17 -0600

Seen: 2,686 times

Last updated: Jun 10 '12