Hi,

njharman wrote:
> Michael Radziej wrote:
>> njharman wrote:
>>> Ticket marked wontfix.  Seems rather harsh to force MySQL users into
>>> editing output of manage.py and commands like 'install' just won't work.
>> Alternatively, set default table type in your database to InnoDB, and
>> you're fine.
> 
> Didn't know such a thing was possible, how excellent.  Thanks.
> 
> command line --default-table-type
> my.cnf       default-table-type
> SQL SET      table_type=INNODB;

Although correct, please note that TYPE is deprecated as of 4.0 and 
might disappear in MySQL 5.2 (it got dropped in 5.1.7 but got revered ;))

Try to use newer versions of these options when possible:
     --default-storage-engine=InnoDB
     SET [GLOBAL|SESSION] @@storage_engine=InnoDB
and
     CREATE TABLE t1 ( id INT ) ENGINE=InnoDB

Again, depends on which version you are using. Small overview here:
  http://dev.mysql.com/doc/refman/5.1/en/news-5-1-8.html
We might need to put that overview somewhere in manual though.. Gonna 
check that out.

Cheers,

Geert


-- 

Geert Vanderkelen
http://www.some-abstract-type-shit.com


--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups 
"Django developers" group.
To post to this group, send email to [email protected]
To unsubscribe from this group, send email to [EMAIL PROTECTED]
For more options, visit this group at 
http://groups.google.com/group/django-developers
-~----------~----~----~----~------~----~------~--~---

Reply via email to