As long as your SQL file does not contain trigger declarations, you can also use DBIx::RunSQL to run SQL. This assumes that the MySQL server retains variables set by the "SET" command and these are not a feature of the mysql command line program. If these are a feature of the mysql command line program, then just run your SQL through that instead.