you should follow two steps:

Create an appropriately named database on the target machine Load the file using the mysql command:

$ mysql -u [uname] -p[pass] [db_to_restore] < [backupfile.sql]

Have a look how...