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 la
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]