Problem with variable settings in sqlFile from mysqldump

Hi there,

i have the problem that when executing a script with sqlFile that directly came from mysqldump, liquibase seems to fail on the comments in the beginning of the file:


it seems that removing the /*!40141 and */ around the set statiement jumps to the next one that has this comment. I tried with option stripComments on and off and it seems to make no difference. Also splitStatements is off,

the error is:

     Reason: liquibase.exception.DatabaseException: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'SET

Ok, solved it myself, but for future reference:

i had the sql file in the same directory as the yaml files. This got scanned by the master and that caused the sql script itself to fail. Moving the sql file itself out of the scanned directory removes the error and it executes fine