The best way of big MySQL database import
If you’re using Phpmyadmin, normally there are limit of db importing – near 2 Mb. If you`ve got much more than this value you may extend php.ini values like
post_max_size. But we won’t consider neither this way here, nor the way through the special dumpers like Sypex Dumper or BigDump. Let’s proceed to the most native, optimal and fast way – over ssh and ftp.
So, the first step is to upload your dump.sql to your server over ftp. Than simply run command in terminal:
mysql -h hostname -u user-name -p DB_name < /path-to-dir/dump.sql
if your host is localhost – than run:
mysql -u user-name -p DB_name < /path-to-dir/dump.sql