Login to SSH. "cd" to you domain directory and where the backup file is.
mysql -h dbhost.domain.com -u user -p db_to_restore_to > backup.sql
I think that's it from memory. Might take some time. I would say use PhpmyAdmin but I guess with that many posts/users it would time out.