How to dump .sql file into DB via linux shell

I am trying to move my PHBB database from my old host to my new dreamhost account. The idea is to fill a new database with the old board data, so i can convert the new database to vbulletin or invision later.

The .sql file is too big to upload via phpmyadmin, it times out. I’ve tried splitting it with rfsplitter but it just gives me a single samesized file. So I’ve uploaded the .sql file to my hostingspace.

I’m not very linux savvy, can someone give or refer me to the exact commands I have to enter to get the contents of that database file into my freshly created one via the linux shell? The reference in the knowledgebase was too vague to really follow.