use your_db

SET autocommit=0;
source the_sql_file.sql;
COMMIT;