sql in file to mysql

[subwiz]

i have series of sql commands in a text file. how do i execute these commands in mysql prompt? is there any way to execute them without cut/paste routine?

[Anon]

mysql -u your_login -p database_name < text_file.sql

[mrblom]

on the prompt,

mysql> . filename

[subwiz]

Thank u guys!