How do I import a .sql DB into MySQL

Hi,
How do I import a .sql DB into MySQL


I'm just learning the basics of creating and editing databases in Mysql working in the mysql.exe DOS prompt on my local Windows machine.

I'm having a really hard time finding the command which will let me import an existing DB. I cant find anything on the mysql site that works. I've also noticed that there seem to be 2 ways to work in MySQL with DOS. One is by launching the mysql.exe dos prompt directly, the other it to just launch a DOS prompt and then navigate to the msql admin application.. which is best?

I'm more familiar with working directly in the mysql.exe application which requires a ; after every command.

Please help a newbie to import an existing database.

Cheers
T.Lance

Try
> type database.sql | mysql -uusername -ppassword dbname

Before that, you need to create the database with
> mysql.exe -uusername -p...
mysql> CREATE DATABASE dbname;

You'll also want to give yourself permission to use it, if you don't have it already...