mysql -u username -p database_name < file.sql
mysql> use db_name; mysql> SET autocommit=0 ; source the_sql_file.sql ; COMMIT ;