On 6/19/08, Russell Keith-Magee <[EMAIL PROTECTED]> wrote: > (2) provide a way to manually disable and re-enable integrity checks. If > someone with more MySQL-fu than me knows how to do either of these
It should work: SET FOREIGN_KEY_CHECKS = 0; ... imported data ... mysql> SET FOREIGN_KEY_CHECKS = 1; ### Cite: This allows you to import the tables in any order if the dump file contains tables that are not correctly ordered for foreign keys. It also speeds up the import operation. Setting FOREIGN_KEY_CHECKS to 0 can also be useful for ignoring foreign key constraints during LOAD DATA and ALTER TABLE operations. However, even if FOREIGN_KEY_CHECKS=0, InnoDB does not allow the creation of a foreign key constraint where a column references a non-matching column type. Peter --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "Django developers" group. To post to this group, send email to django-developers@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-developers?hl=en -~----------~----~----~----~------~----~------~--~---
