St,
There is not reason if you can telnet or ssh in that the above command will not work.
Some hosts require the password to be typed on the same line as is what you see in Infopop's directions.
My host requires the -p and then you enter the password after.
mysql -u USERNAME -p DBNAME < /PATH/TO/BACKUPFILE.sql
DBNAME is the name of an existing database, and USERNAME is a MySQL user with the following privileges for that database: SELECT, INSERT, UPDATE, DELETE, CREATE, DROP, ALTER. Any existing content in the database will be discarded.