How to Import Large Database
Answer 1
It is always recommended to restore large MySQL dumps via command line.
Answer 2
I imported 800 MB database using: unzip -p ‘database.sql.zip’ | mysql -u username -p database
Answer 3
You can also use Bigdump – BigDump: Staggered MySQL Dump Importer 20
Home
Staggered import of large and very large MySQL Dumps (like phpMyAdmin dumps) even through the web servers with hard runtime limit and those in safe mode. The script imports only a small part of the huge dump and restarts itself. The next session starts where the last was stopped.
Very very handy script, i have imported DBes as big as 2GB!
Download here: BigDump