On Aug 7, 6:50 pm, Rob Hudson <[EMAIL PROTECTED]> wrote:
> > Can you get the same result with "default-storage-engine=InnoDB" in your
> > my.cnf?
>
> I believe you can but for other various reasons I'm not able to make
> this change globally.

You can let django create myisam tables, and convert them with one
line of shell:

for t in $(mysql --batch -e "show tables" mydb |grep -v Tables_in); do
mysql -e "alter table $t engine=innodb" mydb; done

Of course, then you need to add foreign key constraints by hand, but
it's pretty easy to do, and you get more control on ON CASCADE / ON
DELETE statements.

Ludo


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

Reply via email to