If the database is a large one, you might want to upload it (username_databasename.sql) somewhere onto your account, for example to directory you created named dbbackup; /home/username/dbbackup/ and then ask your host to restore it for you via SSH. If you have shell access and want to restore it yourself you could try a command something like this:
Code:
mysql -u username_databaseuser -p username_databasename < /home/username/dbbackup/username_databasename.sql
And provide the password when asked during the restore.