Nico Rittner wrote: > hello, > > does anybody now how mysqldump handles the actions > for 'on delete' and 'on update' ? In my Version 4.1.14 > the action clauses are missing. When reimporting the > dump, how does mysql know about the 'action' when altering > the table with forein keys. > > Thanks, > > Nico
Hi Nico, are you using the InnoDB storage engine for your tables? If not, the clauses will not be included in the dump, as only InnoDB supports foreign keys. When you create a non-InnoDB table which has a foreign key specification, MySQL just ignores the specification. Cheers Frank -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
