Nico Rittner wrote: > Hallo, > >> Sorry to ask this questions, but are you confident that the action >> clauses work properly, i.e. the tables were created correctly? > > In the case of a crash i need to restore the dump including > the on delete/update clauses. > >> What do you see when you execute "show create table groups"? > > CREATE TABLE `groups`( > > .... ( the same as mysqldump shows - but without 'on delete/update' ) > > > ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COMMENT='groups' > > > Thanks, > > Nico
Hi Nico, what I meant was: are you sure that the tables which are in your database are defined correctly, i.e. have the actions? The fact that "show create table" does not display them, implies that they might have been "lost" somewhere. Can you post the statement which has been used to create the groups table in the first place. Cheers Frank -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
