MySQL Forums
Forum List  »  Data Recovery

Re: mysqldump creates conditional comments that lead to errors when restoring
Posted by: Peter Brawley
Date: May 19, 2017 12:33PM

Conditional SETs are to smoothe the restore proces, eg unsetting foreign key checks allows a table and/or its rows referenced by a foreign key in a later declared table to be dropped and recreated,

The error would occur if the SET statement for an @old... variable is missing. When you restore, do you run the whole dump file, or do you abstract some part of it?

Options: ReplyQuote

Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.