If you want to restore a database, you have to follow these steps.
1) Use ftp to upload the file
2) Login to the server, and cd to the directory that you have uploaded.
3) Execute the command.
mysql -u usernaem -p password databasename < databasename.sql
where username is the mysql username
password is the mysql user password
databasename is the name of the database to be restored.
databasename.sql is the dump file or the backup file.