Pls help me upload my MySql database to my new server

I transferred my site to a new hosting (Dreamhost), no database created yet.

I have backed up my mysql database and stored in my hard drive.

How can I upload my site's database to my new hosting?
Do I need a software to upload it? Where can I get a free one?

Please help.

Thank you..

-Gene

Ehh... I doubt they'd let you muck around with the actual database files.
What you should do is backup everything as SQL statements, ie, CREATE DATABASEs, CREATE TABLEs, INSERTs, and so on. Then execute that code on the server.
Though they might not let you do CREATE DATABASE statements; you'd have to create it somewhere else (like through a phpMyAdmin or cPanel, if installed).