Philip, DROP TABLE always succeeds even if you would have child rows referring to it.
Thus the way is dump + DROP + CREATE + import Best regards, Heikki Tuuri Innobase Oy --- Order technical MySQL/InnoDB support at https://order.mysql.com/ See http://www.innodb.com for the online manual and latest news on InnoDB Philip Molter wrote in message ... >Is there a way to disable foreign keys temporarily? Specifically, >I'm running 3.23.47 with InnoDB tables, and I need to periodically >dump and reload a table that has foreign key dependencies on it. > >Thanks, >Philip > >* Philip Molter >* Texas.net Internet >* http://www.texas.net/ >* [EMAIL PROTECTED] --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php