Am hoping someone can give me the safest advice here.

Using 4.1 and InnoDB, someone in an attempt to be helpful set up a lot
of foreign key constraints. However...

ON DELETE CASCADE

When we needed RESTRICT.

Net effect? Some editing today lead to cries of "Where has half the data
gone?"

We have the binlog, and know the point at which the erroneous stuff
happened - however, no backup exists, so I can't roll forward from that
(don't ask)...

Is it at all possible to rollback using the binlog to that point? Or is
it time to get back to manual data entry?

Any help greatly appreciated.

Rob

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/[EMAIL PROTECTED]

Reply via email to