[EMAIL PROTECTED] ("Phil Butterworth") wrote in news:[EMAIL PROTECTED]:
> Is their a way to disable constraints for the new > tables, then when all the tables are created the FK's are put into > place, so no create table statement errors because of FK's, and no > editing the sql dump? SET FOREIGN_KEY_CHECKS=0; -- do your stuff SET FOREIGN_KEY_CHECKS=1; -- felix -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]