re: Backups with InnoDB foreign keys

2003-03-21 Thread Egor Egorov
On Thursday 20 March 2003 23:25, Andreas wrote: > I'm trying to get going with InnoDB. > As for now I created several tables which relate to each other with some > foreign key restrictions. > > mysqldump --all --opt writes 6++ MB stuff in a textfile that mysqld > won't accept without SET FOREIG

Backups with InnoDB foreign keys

2003-03-20 Thread Andreas
I'm trying to get going with InnoDB. As for now I created several tables which relate to each other with some foreign key restrictions. mysqldump --all --opt writes 6++ MB stuff in a textfile that mysqld won't accept without SET FOREIGN_KEY_CHECKS=0; After SET FOREIGN_KEY_CHECKS=1; is my