[chiPHPug-discuss] Import/restore .sql file?

[Janine S. <jr...@ba...>]

I am attempting to mirror SMF on my WinXP laptop to test upgrades.  I 
have Apache, PHP, mySQL, and one working install of Drupal all tested 
and running.  Apache, PHP and mySQL are all installed in c:\Program 
Files.  Database is created and empty and I exported the .sql file 
through phpMyAdmin from my public server.

After logging in to mysql and using the database, at the command line 
mysql> I enter:
mysql -u **** -p ****** -h localhost database < filename.sql;
where user and password is for mySQL

and get:
ERROR 1064 (42000): You have an error in your SQL syntax; check the 
manual that
corresponds to your MySQL server version for the right syntax to use 
near 'mysql
-u **** -p ******* -h localhost database < filename.sql' at line 1

I have also tried exiting mysql and changing (with cd) to the MySQL 
subdirectory (where the .sql file is).  That gives me a long list of 
commands instead of an error message, but the database is still empty 
and I am not running mysql when the commands finish listing.

I have tried taking out the spaces after -u and -p.  I've tried leaving 
the space after -u, no space after -p and no space after < with ./ as 
the path.

I tried installing MySQL Tools and using the MySQL Administrator, it 
said it can't restore files generated by mysqldump.

What am I doing wrong?  Where should I put the .sql file and how should 
I list the path?  Which spaces are needed?

Thanks!
Janine