First time here? Check out the FAQ!
Ask Your Question
4

How to edit Django's settings.py file to use MyISAM MySQL storage engine?
 
   
  
 
 
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.
 
 
To enter a block of code:
 
     
  • enter empty line after your previous text
    •  
  • paste or type the code
    •  
  • select the code and press the  button above
    •  
 
Preview: (hide)
  
 
 
 
 
 
 ubi_com's avatar

      41
    
 
 
 
 ubi_com 
 
 
    asked 12 years ago 
 
 
 
 
 Evgeny's avatar

      13.2k
    
 
 
 
 Evgeny 
 
 
    updated 12 years ago 
 
 
 
 
        
 
 
 
Comments
 
 
 
  see more comments  
 
 
 
 
 
 2 Answers
  
  
  
 
 
 
 
3
 
 
  
 
 
 
 
 
 
This stackoverflow post will hopefully help you.
 
At this time we do not support the "new style" databases settings, use DATABASE_OPTIONS setting instead.
 
 
To enter a block of code:
 
     
  • enter empty line after your previous text
    •  
  • paste or type the code
    •  
  • select the code and press the  button above
    •  
 
Preview: (hide)
  
 
 
 
 
 
 Evgeny's avatar

      13.2k
    
 
 
 
 Evgeny 
 
 
    answered 12 years ago 
 
 
 
 
     link   
 
 
 
Comments
 
 
 
 
  
 
 
 
Thanks a lot! I have achieved to created MyISAM databases to add DATABASE_OPTIONS at settings.py.
 
 
 ubi_com's avatar ubi_com (12 years ago)   
 
 
  
 
  see more comments  
 
 
 
  
 
 
 
 
-1
 
 
  
 
 
 
 
 
 
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
 
 
To enter a block of code:
 
     
  • enter empty line after your previous text
    •  
  • paste or type the code
    •  
  • select the code and press the  button above
    •  
 
Preview: (hide)
  
 
 
 
 
 
 naavi's avatar

      185
    
 
 
 
 naavi 
 
 
    answered 12 years ago 
 
 
 
 
     link   
 
 
 
Comments
 
 
 
 
  
 
 
 
I'm not alone to use this machine.
 
 
 ubi_com's avatar ubi_com (12 years ago)   
 
 
  
 
  see more comments