My friend is trying to restore a database that is over 800 MB and he cannot restore it through phpmyadmin as it times out a lot. Are there any other methods?
Best, and fastest way, is to use ssh to restore the database. If you have access, you can do it. If you do not have ssh access, I would contact your hosting provider and ask them to import the database.
My friend contacted his hosting provider and they replied saying that enabling ssh access can be bad as hackers will attack the opened port so they won't enable it. @ sizzlefire: He's going to try bigdump and i'll update you if it works or not.
Bigdump does work, I've used it fairly often. As for the SSH, sure they might not enable it for your friend however your friend should be able to ask the provider to restore the database for him through SSH rather than your friend do it. I don't see any problem with using BigDump though, it's worked for me multiple times.