Importing large DB file into mySQL

Phpmyadmin is a great DB tool but can really suck on trying to import large DB files. Another much better option is to use bigdump.

Over at DrupalLab, they have written some easy step by step guide on using bigdump.